If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Populating Form from another form's data
I have 2 tables, both of which contain last name, first name, and MI as field
names. I have built a membership form that contains the main demographic information for the person and from there the end-user clicks on a button that takes them to another form to complete some dated information. I need the following to happen when the button is clicked: 1. Pull up the information that is already contained in that 2nd dated table 2. Allows the user to add new information 3. Populates the key fields (last name, first name, MI) without the end-user having to re-type it. Help please???? |
#2
|
|||
|
|||
Populating Form from another form's data
1. You can drop a command button on the form and follow the wizard prompts.
It will ask you if you want to display all the records in the table or just specific ones. (You want just specific ones). 2. You can do this with a form as long as the allow edits and allow additions properties are on (which they are unless you turned them off). 3. You should not store this information in 2 places. Instead use a DLookup function on the second form to read it in and display it from the first table. Robert "Stacey" wrote in message ... I have 2 tables, both of which contain last name, first name, and MI as field names. I have built a membership form that contains the main demographic information for the person and from there the end-user clicks on a button that takes them to another form to complete some dated information. I need the following to happen when the button is clicked: 1. Pull up the information that is already contained in that 2nd dated table 2. Allows the user to add new information 3. Populates the key fields (last name, first name, MI) without the end-user having to re-type it. Help please???? |
Thread Tools | |
Display Modes | |
|
|