Hi Rod, The quick and dirty way is to make a query to serve as the form's recordsource. Assuming you want to prompt for the Employee ID number, you would put something like this in the EmployeeID column of the query design grid:
[Employee ID number] Don't forget the square brackets! Open the query to see the behavior: A dialog box pops up with the title "Enter Parameter Value". Below, it says "Employee ID number" (or whatever you typed between the square brackets). When you click OK, the query (or form) opens with the matching record. Good luck, Peter Hoogenboom --- In [email protected], "Rod_SmithSr" <[EMAIL PROTECTED]> wrote: > > I am tryin to create a dialog box that prompts me for a specific and > opens that record's form. Can anyone help? >
