ACCESS FEED: [MS_AccessPros] Re: Assistance needed with form/subform

Kamis, 14 Juli 2011

[MS_AccessPros] Re: Assistance needed with form/subform

Hi Toukey,

I have to be gone for about an hour but I will get back to you when I can.

Kind Regards,
Pat Wood
http://accesstips.wordpress.com

--- In MS_Access_Professionals@yahoogroups.com, toukey1 <no_reply@...> wrote:
>
> Hi,
>
> This is the subform record source:
>
> SELECT Service.ServiceID, Service.[Service date], Service.[Service time], Service.Quantity, Service.T_DescriptionID, ServiceType.ServiceTypeID, ServiceType.ServiceName, Service.CustomerID
> FROM ServiceType INNER JOIN Service ON ServiceType.[ServiceTypeID] = Service.[ServiceTypeID];
>
> This is the rowsource for the servicetypename combo box:
>
> SELECT ServiceType.ServiceTypeID, ServiceType.ServiceName
> FROM ServiceType
> ORDER BY ServiceType.[ServiceName];
>
> Thanks for your assistance.
> Toukey
>
> --- In MS_Access_Professionals@yahoogroups.com, "patrickawood" <pwood57@> wrote:
> >
> > Hi Toukey,
> >
> > Can you post the the Subform's RecordSource for us? If it is a Query can you post the Query's SQL?
> >
> > Also can you post the Subform servicetypename combo box's RowSource SQL or Query SQL for us?
> >
> > Kind Regards,
> > Patrick Wood
> > http://accesstips.wordpress.com
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, toukey1 <no_reply@> wrote:
> > >
> > > Hi, I am trying to create a form/subform where the main form would have the customer details and the subform would have service details.
> > >
> > > Tables
> > > ------
> > > I have 3 tables in my database:
> > > 1. Customer with the fields: CustomerID, lname, fname, address
> > > 2. ServiceType with the fields: ServiceTypeID, ServiceTypename
> > > 3. Service with the fields: ServiceID, CustomerID, ServiceTypeID, servicedate, servicetime, qty, desc
> > >
> > > Relationships
> > > -------------
> > > Customer.CustomerID has a one-to-many relationship with Service.CustomerID. ServiceType.ServiceTypeID has a one-to-many relationship with Service.ServiceTypeID.
> > >
> > > Form
> > > ----
> > > On my main form I have the customer details with a combobox for the user to select the customer and the name etc. is populated. However, when I open the form, the customer info is already being populated - Don't know exactly why when it should be blank.
> > >
> > > The subform has the service info. I want to be able to put a combo box for the servicetypename for the user to select and then the user will fill in the other details. This I am not getting to work. Also I want to be able to have more than one type of service for the same customer. Not getting this to work at all.
> > >
> > > This is how I want my form to look
> > >
> > > Customer ID 0001
> > > Customer LName Customer Fname
> > > Address
> > > Service ID
> > > Service Date
> > > Service Time
> > >
> > > ------------------------------------------
> > >
> > > ServiceTypeName QTY Desc
> > > Rotation 0 Rotation Desc
> > > Balance 2 Balance Desc
> > >
> > > Any help would be appreciated.
> > >
> > > Regards
> > > Toukey
> > >
> >
>