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.
 
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
 
Back
Top