Passing values between forms

casper

Registered User.
Local time
Today, 00:50
Joined
Aug 26, 2006
Messages
12
Ok this is probably easy for you guys but my knowledge of access is limited.

I have two forms - Find Job and Notes
On the Find Job form I have a text box called 'Job No' and a combo box called 'Status' that I have coded to open Notes if certain conditions are met. The code is

Code:
Private Sub Status_AfterUpdate()
If Status.Value = "WIP - Snagged" Or Status.Value = "WIP - Suspended" Then
DoCmd.OpenForm "Notes", , , acFormAdd
End If

What I need is to be able to pass the value of the 'Job no' text box on the Find Job form to the 'Job No' text box on the Notes form.

Many thanks in advance

Michael
 
Found the answer

Forms!Notes!txtJobNo.Value = Me!txtJobNo.Value

I changed the name of the text boxes after I had posted the original question.
 

Users who are viewing this thread

Back
Top Bottom