Filtering forms before while opening them.

[Talismanic]

I have a form that displays look up information for the payroll dept that lists all the charges to a job. The Job Number and Name are in the header and the charges are in the detail section. The problem is that there are several jobs listed. I would like to make a dialog box for the user to enter the job number before the form opens so that the form will only display the charges for that one job. Is this possible? By the way, it is not a problem if the user has to close the form and reopen it every time for a new number.

 

[Carol]

Create a Dialog Box with an unbound Text Box. Name this text box "JobNumber".
In your query in the criteria line for your Job field, insert the following:
[Forms]![DialogFormName]![JobNumber]
You could also do this by having a combo or list box that displays all entered jobs. It would be set up the same, except that your record source for the unbound combo or list box would be a query that retrieves all job numbers.
Good luck.