Tab options in a from

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simplyanjel - 29 May 2008 22:07 GMT

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!!! :)

Signature

Simplyanjel
A/R Data Analyst

Reply to this Message

Al Campagna - 30 May 2008 13:56 GMT

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 & "*"

Signature

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."

>I have a form that runs from a parameter query. It has 4 options to query
>the
[quoted text clipped - 4 lines]
>
> TIA!!! :)

Reply to this Message

Simplyanjel - 30 May 2008 16:11 GMT

Al Campagna,

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

Thanks!

Signature

Simplyanjel
A/R Data Analyst

> Simplyanjel,
> Create a pop up form with 4 unbound text controls (or Combo or Lisbox...
[quoted text clipped - 11 lines]
> >
> > TIA!!! :)

Reply to this Message