Combo Box for parameters

  • Thread starter Thread starter tinab
  • Start date Start date
T

tinab

I created a form with a combo box with categoryID. I want to select
the category in this combo box and have the Products form open and
show only those records. I have tried entering the form name and
control in the criteria of the cateogyID in the Product form's record
source query. I put Forms!FormName!ControlName in the criteria field.
Instead of my form opening, I always get the MSAccess default form
with text that I entered into the criteria field. Why won't my form
that I am referencing in the criteria field open? It's probably
simple but I just don't understand! What am I doing wrong? Thank
you.
 
Try if this work for the criteria field.

Forms!FormName.ControlName
 
I still get the access default parameter form asking for the criteria
and not my dialog box. Any other suggestions? It is so frustrating!
Thanks, Tina
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top