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
>
Tidak ada komentar:
Posting Komentar