Opening a form based on another form's number

superrob5

Registered User.
Local time
Today, 16:05
Joined
May 8, 2003
Messages
99
I am trying to open another form based on a number from another form.

There is a job number that can be associated to a helpdesk call.

So on the helpdesk form there is a field called JobNumber and on the job form is the same. I want to be able to open the form based on a button. I thought it would be
[JobNumber]=[Forms]![LOGENTRYJD]![JobNumber]
 
DoCmd.OpenForm "MyForm", , "JobNumber = " & Forms!OtherForm!MyControl

I might not have the expression in the correct parameter, however.
 

Users who are viewing this thread

Back
Top Bottom