Hello. I have a form in my database with a command button that opens another form (based on a related table) at a new record. I would like two pieces of data from the record displayed on the original form to be automatically filled in on the newly opened form. Can anyone help? I'd really appreciate it.
open form&fill in data
- Thread starter arkres
- Start date
You might check out my post from yesterday: http://www.access-programmers.co.uk/ubb/Forum6/HTML/000281.html
The part that works for me should work for you, though it uses a macro, you should be able to just do the open form/gotocontrol/setvalue actions to where your ID fields match each other. I'm sure there's a better way to do this, but I never got much input when I was trying to figure it out.
HTH
The part that works for me should work for you, though it uses a macro, you should be able to just do the open form/gotocontrol/setvalue actions to where your ID fields match each other. I'm sure there's a better way to do this, but I never got much input when I was trying to figure it out.
HTH
Travis
Registered User.
- Local time
- Today, 15:40
- Joined
- Dec 17, 1999
- Messages
- 1,332
After you open the form then just do this
Private CommandButtonToOpenForm_Click()
'...Your code to open the form
'Now set the variables
Forms![TheSecondFormName].[TheFirstDataFieldName] = Me.[TheFirstDataFieldName]
Forms![TheSecondFormName].[TheSecondDataFieldName] = Me.[TheSecondDataFieldName]
End Sub
Private CommandButtonToOpenForm_Click()
'...Your code to open the form
'Now set the variables
Forms![TheSecondFormName].[TheFirstDataFieldName] = Me.[TheFirstDataFieldName]
Forms![TheSecondFormName].[TheSecondDataFieldName] = Me.[TheSecondDataFieldName]
End Sub
