Tab options in a from

[Simplyanjel]

I have a form that runs from a parameter query. It has 4 options to query the
form by and I have it set to use the wildcard option in all fields. Is there
a way to get it where all the parameters so up on one screen at the same
time, where the user can tab through them all and then hit enter?

TIA!!!

 

[Al Campagna]

Simplyanjel,
Create a pop up form with 4 unbound text controls (or Combo or Lisbox...
etc), to accept the 4 values you need.
Then have your query use those value/s from the open pop up, as criteria
when the form opens.
Ex. a field called [City] on the form...
Like Forms!frmMyPopUp!City & "*"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Simplyanjel]

Al Campagna,

Thank you so much for your help!!!! It worked perfectly.

Thanks!
--
Simplyanjel
A/R Data Analyst

Simplyanjel,
Create a pop up form with 4 unbound text controls (or Combo or Lisbox...
etc), to accept the 4 values you need.
Then have your query use those value/s from the open pop up, as criteria
when the form opens.
Ex. a field called [City] on the form...
Like Forms!frmMyPopUp!City & "*"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."