Populating Form from another form's data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stacey - 30 Dec 2007 20:30 GMT

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????

Reply to this Message

Robert - 30 Dec 2007 22:10 GMT

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

>I have 2 tables, both of which contain last name, first name, and MI as
>field
[quoted text clipped - 10 lines]
>
> Help please????

Reply to this Message