Disable parameter prompt when opening form

  • Thread starter Thread starter NKK
  • Start date Start date
N

NKK

I have a form with 6 dependant combo boxes (2 groups of 3); datasource1,
table1, column1, datasource2, table2, column2. I have an after-update event
to requery the "next" control on datasource and table and I have a
parameterized row source for table and column that take the value from the
"previous" control (So, table 1 takes datasource_id from datasource 1, etc.)
This form is for the user (me) to enter entity relationship information. I
would like to be able to open the form without the parameter query prompts.
I could have sworn I had done this before, but for the life of me I can not
remember how and I can not seem to find any examples either. Please help!
Thanks!
 
If you've saved the filter in the form, you'll need to go into design view
and delete the filter. If not, it probably is in the underlying query, and
you'll need to clear that criteria.
 
Back
Top