Form Question

[Guest]

I have a data entry form that a user inputs all of the customer's info into.
One of these fields is a pager. As the customer walk in, they are assigned
this number on this entry page.

I have another form that automatically updates witht the customer
information after the data entry form is saved.

I need to place this pager field in the updated form. How can I do that?

 

[John Vinson]

I have a data entry form that a user inputs all of the customer's info into.
One of these fields is a pager. As the customer walk in, they are assigned
this number on this entry page.

I have another form that automatically updates witht the customer
information after the data entry form is saved.

I need to place this pager field in the updated form. How can I do that?

Base both forms on the same table (or a query upon the same table).

Forms are *just windows*. They are not data storage repositories; you
don't enter data "into a form", you use a Form as a tool to enter data
into a table. Once the data is in that table, then other forms,
queries, or reports can get at it.

Note also that "saving a form" generally saves only design changes to
the structure of the form; it is not necessary to do anything other
than move to a new record or close the form to save data to a table.

John W. Vinson[MVP]