Forms and Queries and AutoFills ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

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

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
:o)
 
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
 
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
:o))
 
Back
Top