Opening a form with a screen pop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have a form that contain workers information. When I open the form I would like a screen pop to appear asking for a last name so the form will open directly to that persons record. Is this at all possible

Thank you in advance for your response

Mike
 
Mike said:
Hello,
I have a form that contain workers information. When I open the form
I would like a screen pop to appear asking for a last name so the
form will open directly to that persons record. Is this at all
possible?

Thank you in advance for your response.
Click to expand...

I'm not sure what you mean by a "screen pop", but there are several ways
you could make this happen. Do you want the form to open so that it
shows *only* the record(s) for the specified last name, or do you want
the form to show records for all workers but just be positioned to the
name entered? If the former is what you want, then the simplest --
though not the most elegant -- way, is to base the form on a parameter
query, where the parameter is the last name. For example, a query along
these lines:

SELECT * FROM WorkerInfo
WHERE LastName = [Enter worker's last name];

You would have to substitute your own form and field name, of course.
 
Hello,
I have a form that contain workers information. When I open the form I would like a screen pop to appear asking for a last name so the form will open directly to that persons record. Is this at all possible?

Thank you in advance for your response.

Mike
Click to expand...

I have no idea what a screen pop is, but if you wish the form to
display a particular record, perhaps the simplest method is to add an
unbound combo box to the form (header).
If you use the Combo Box Wizard, select the 3rd option on the first
page of instructions, something like "Find a record that matches ..."
etc.

When done, simply select the WorkerID, Worker Name, from the combo box
and the form will fill in with that person's record.
The nice thing about this method is that you can use the combo box
whenever the form is open, not just when opening it.
 
Back
Top