Button to open a new form using current ID

D

David McLean

Hi there,

I've got a form that shows the results of student workplacements, and one of
the fields gives the Employer name. I have button that opens another form
which has contacti nformation for the employer, but I'm having trouble
getting it to open the new form to the current employer. Any ideas?

Thanks
David
 
F

fredg

Hi there,

I've got a form that shows the results of student workplacements, and one of
the fields gives the Employer name. I have button that opens another form
which has contacti nformation for the employer, but I'm having trouble
getting it to open the new form to the current employer. Any ideas?

Thanks
David
Click to expand...

You may be displaying the Employer Name on this form, but I hope there
is a unique Prime Key EmployeeID field on your form and in the table.

Code a command button click event on Form1 to open Form2:

DoCmd.OpenForm "Form2", , , "[EmployeeID] = " & Me.[EmployeeID]

The above assumes [EmployeeID] is a Number datatype.
If it is Text, then use:
"[EmployeeID] = """ & Me.[EmployeeID] & """"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to open a sub form and filter it on 2 fields 1
Access linking new student form to new course form 2
trouble using button to open new form to add new record 1
How to finding student Rank and How to upload bulk marks of each student at a time. 1
How do i set open form to current record? 8
how do I open a new form with a cmd button using data in current f 8
How to add a button to a form that opens another form 7
"Open Form" Button Function 7

Top