Exporting Information to a Form

[z03wpd]

I'm making a customer database for my small business. I have already
designed a form to input customer information into the database. Is there a
way to export some of the information into a different form(s)?

 

[Douglas J. Steele]

Forms don't have data: the data is in tables. (Think of forms as windows
into the data).

Yes, you can have a second form that gets it data from the same table(s) as
another form.

 

[z03wpd]

Forms don't have data: the data is in tables. (Think of forms as windows
into the data).

Yes, you can have a second form that gets it data from the same table(s) as
another form.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)





Thank you. I do understand that a form can either enter data into a table, or display data already in table. How can I take some data (like a customers name, address, and phone number) and put it into another form?

 

[Douglas J. Steele]

You don't "take data...and put it into another form".

If you want to display additional data on the second form, determine where
it's stored, and either add that data to the recordsource of the second
form, or else add a subform to the second form to show the additional
information.

Take a look at the forms in the Northwind database that came with Access.
See how some of them (such as Customer Orders) use subforms to display the
data from other tables and others (such as Quarterly Orders) are based on
queries that join multiple tables together.

 

[John Vinson]

Thank you. I do understand that a form can either enter data into a table, or display data already in table. How can I take some data (like a customers name, address, and phone number) and put it into another form?

Reread Douglas' message.

You don't "put data into another form" any more than I put the Owyhee
Mountains in my office window.

You open another Form using the table containing the desired data as
that form's Recordsource.

If you're trying to take the data out of one table and store it
redundantly into another table... *don't*. That violates the whole
reason that relational databases exist - you store data ONCE, in one
place, and then in the future use Queries to link to it and display
it.

John W. Vinson[MVP]

 

[z03wpd]

You don't "take data...and put it into another form".

If you want to display additional data on the second form, determine where
it's stored, and either add that data to the recordsource of the second
form, or else add a subform to the second form to show the additional
information.

Take a look at the forms in the Northwind database that came with Access.
See how some of them (such as Customer Orders) use subforms to display the
data from other tables and others (such as Quarterly Orders) are based on
queries that join multiple tables together.