Hi
2 of my tables are called company and shop.
I have a table (I'll call it Main) which has many fields, 2 of which are called company and shop and these 2 fields lookup from the 2 tables.
I know that you guys hate lookups but this is what I have !!!!
I then have a form based on the main table.
The field 'company' on this form uses the lookup defined in the table to drop down a list of companies for the user to choose from.
What i then want is for the field 'shop' to drop down a list of shops which is a subset of all shops based on the entry in field 'company'
To achieve this I have a query which uses forms!main!company as the criteria and I use this in the rowsource property of the shops field.
When entering a 'main' record all seems fine and the correct shops for the company entered are displayed in the drop down list and when the user selects a shop it is displayed in the field.
However, the value for shop is not then stored in the main record and of course I want it to be.
Can someone please tell me why and whether there is something I can do to achieve this?
cheers
Phil
I have a form where one of the fields drops down a list which is based on a query which is dependent on the value entered in another field.
The correct list
Kamis, 10 Mei 2012
[MS_AccessPros] Table not being updated
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar