Kamis, 10 Mei 2012

[MS_AccessPros] Table not being updated

 

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar