Open a form and pass a parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan T - 25 May 2007 04:41 GMT

I have a main form displayere list of employees.
I would like to open a second form to display the details of a selected
employee. How can I do that?

One way I am thinking of is pass the employee number as argument when open
the second form.

Reply to this Message

fredg - 25 May 2007 05:28 GMT

> I have a main form displayere list of employees.
> I would like to open a second form to display the details of a selected
> employee. How can I do that?
>
> One way I am thinking of is pass the employee number as argument when open
> the second form.

You don't need to pass the second form the employee number.
All you need do is open the second form (from the already open first
form) using the where argument of the DoCmd.OpenForm method.

Assuming the [EmployeeID] datatype is Number:
DoCmd.OpenForm "Form2", , , "[EmplyeeID] = " & Me![EmployeeID]

Form2 will open showing the records of the employee selected on Form1.

Look up the OpenForm method in VBA help.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message