Copy data from one form to another

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Is it possible to send data form one form to another, I have an Attendees
form which has attendee adress fields, a lot of these attendees have the
same addresses, I want to open a search address form and send that data back
to the attendees form (which will still be open). I have the search form
working how do I send the data to the other form when closing the search
address form?

Hope you can help

Thanks

Phil
 
Sorry about double posting, I have sorted this one out, I used

Forms!Attendees!Address = Me.Address
Forms!Attendees!City = Me.City
Forms!Attendees!StateOrProvince = Me.StateOrProvince
Forms!Attendees!Country = Me.Country
Forms!Attendees!PostalCode = Me.PostalCode

On Error GoTo Err_Close_Form_Click

DoCmd.Close

Exit_Close_Form_Click:
Exit Sub

Err_Close_Form_Click:
MsgBox Err.Description
Resume Exit_Close_Form_Click

which works

Thanks

Phil
 
Sorry about reposting, I keep getting an error from the web based form, I
have sorted this using

Forms!Attendees!Address = Me.Address
Forms!Attendees!City = Me.City
Forms!Attendees!StateOrProvince = Me.StateOrProvince
Forms!Attendees!Country = Me.Country
Forms!Attendees!PostalCode = Me.PostalCode

On Error GoTo Err_Close_Form_Click


DoCmd.Close

Exit_Close_Form_Click:
Exit Sub

Err_Close_Form_Click:
MsgBox Err.Description
Resume Exit_Close_Form_Click


Thanks

Pghil
 
Sorry about reposting, I keep getting an error from the web based form, I
have sorted this using

Forms!Attendees!Address = Me.Address
Forms!Attendees!City = Me.City
Forms!Attendees!StateOrProvince = Me.StateOrProvince
Forms!Attendees!Country = Me.Country
Forms!Attendees!PostalCode = Me.PostalCode

On Error GoTo Err_Close_Form_Click


DoCmd.Close

Exit_Close_Form_Click:
Exit Sub

Err_Close_Form_Click:
MsgBox Err.Description
Resume Exit_Close_Form_Click


Thanks

Pghil
 
Back
Top