Unanswered: saving field from one form onto another form
I have a form that I want users to input new data on, and on this form I create a button that launches another form to help select input for the field on the first form. I can launch the second form, and get the data in one of the fields that I want, but then I want to make a button that will:
1) Write the value that I wish to have saved on the pop up form into the field that I wish it to save to on the main form.
2) Close the form.
There is a form close function built into access already, but not knowing vb and being unable to find any resources to learn I am stuck! I learn as I go along, and all of you are the teachers. Please help, I am going crazy.
Its the generated code from the button wizard, as displayed below
Private Sub Command26_Click()
On Error GoTo Err_Command26_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "neededpartspopup"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Do you have code for that close button? You should be able to.. Either that or you can use another event from the popup to send the value back to the main form.. Just depends really on how you want it to happen