Filter Information.

[avw410]

I have a Form that pulls information from different tables and queries but I
would like to be able to filter only certain information if its possible.
here is what I currently do. I have a mainboard with buttons. I click a
button to open the Form. The Form shows job numbers, record numbers, and
other information. I than have to use the next/previous buttons or the
search to find information. what I would like to be able to do is only show
the information for a selected job number or when I click the button to open
the Form have it ask me for the job number and than only show that job
information.

 

[KARL DEWEY]

Place a criteria prompt in the query that is the source for the form like
this --
[Enter Job Number]
Or for a sequence of job numbers like this --
Between [Enter Beginning Job Number] AND [Enter Ending Job Number]
Or to enter just the start of job number --
Like [Enter Job Number] & "*"

 

[avw410]

That works great. Thank you.

Place a criteria prompt in the query that is the source for the form like
this --
[Enter Job Number]
Or for a sequence of job numbers like this --
Between [Enter Beginning Job Number] AND [Enter Ending Job Number]
Or to enter just the start of job number --
Like [Enter Job Number] & "*"
--
KARL DEWEY
Build a little - Test a little

I have a Form that pulls information from different tables and queries
but I
would like to be able to filter only certain information if its possible.
here is what I currently do. I have a mainboard with buttons. I click a
button to open the Form. The Form shows job numbers, record numbers, and
other information. I than have to use the next/previous buttons or the
search to find information. what I would like to be able to do is only
show
the information for a selected job number or when I click the button to
open
the Form have it ask me for the job number and than only show that job
information.