Automatically Populate Form if 'Yes' chosen from field

  • Thread starter Tena via AccessMonster.com
  • Start date
T

Tena via AccessMonster.com

I have a field in one form that when a user chooses 'Yes' I want another form
to automatically populate. How would this be done?
 
K

kew

If all the values are on form 1 and they just need to be moved to form
2 use the on click event to send the values to the other form.

*********Use the following commands (look up proper syntax)
[your info]
DoCmd.openform "[your second form]"
forms![form name]![text name].value=[your value, use same format but
other form]
Repeat for all data to transfer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate a field on a form 0
populating field 3
Pop-up form when a certain value is chosen 0
Populating fields in a newly created form in Access 2007 3
Access forms fill in 1
Auto-populate a form 4
combo box selection will not populate query correctly 1
Extract value from specific record to populate a new record 7

Top