Forms and Queries and AutoFills ...

S

SianH

Hi,

I've tried and tried but just can't find a way to do it :eek:(

I have a field called Product Type (which gets a distinct list of product
types from one table). I then have a field called Product Model, which I
want to get from the same table, but restrict rows based upon Product Type
already selected.

I can get Access to do this the first time you pick a Product Type, but if
you change your mind on the Product Type and select a different one, it
doesn't update the Product Model.

Can anyone help? I'm sure it's really stupidly simple, but I just can't get
it to do it!

Thank you
:eek:)
 
D

Dennis

I assume when you say fields you mean list boxes or combo boxes.
In the after update event of product type put the following code
ProductModel.Requery
 
S

SianH

Hi Dennis,

Thank you SO SO much - I knew it had to be easy, but I just couldn't see it.
(and I did mean combo boxes).

Thanks again
:eek:))
 
Top