combo box that sets critia for mext combo

[Guest]

Hi,

I've seen simular post to this problem but no resolution. Heres what I am
doing. I have a table which has a product id and a model id in it. I want to
limit the items for selection in the model id based on the selection in the
combo product id. I've tryed all kinds of things, but I cannot get the
correct results. I'm sure I am missing somthing simple here any help would be
appreciated.

PB

 

[Van T. Dinh]

Are you trying to do this in the DesignView / DatasheetView of the Table or
in a Form?

The former case is _not_ possible. On a Form, you can try:

http://www.mvps.org/access/forms/frm0028.htm