Form to Update Table and Receive Data from Query

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I am creating a database in Access 97 that will eventually
be loaded into a machine running OfficeXP. I'm sure this
ispossible, but don't know how to do it:

I created a form to update data in a table. One of the
pieces of data I enter in is a Customer ID (there are may
customer ID). I used the lookup function, so this helps
with accuracy, but I would like to see the full name
before saving the data. How can I view linked data from a
query that would show more information on the Customer ID
entered; or how can I pop up a summary of the data about
to be entered, before committing it?

THanks.

Ken
 
I created a form to update data in a table. One of the
pieces of data I enter in is a Customer ID (there are may
customer ID). I used the lookup function, so this helps
with accuracy, but I would like to see the full name
before saving the data. How can I view linked data from
Click to expand...
a query that would show more information on the Customer ID
entered; or how can I pop up a summary of the data about
to be entered, before committing it?
Click to expand...

Ken,

If you defined a field with Lookup in Table Design view,
there has been much discussion here advising against it.

The general strategy here is to:

- define the customer number field with the same datatype
as your customer number field (if it is an AutoNumber, use
type Integer)

- place a combo box on your form. Use the wizard, telling
it to look up values in another table, choose the first
two columns to display, accept the default "Hide key
column", and have it store the chosen value in the desired
field.

This will DISPLAY the name, but actually STORE the
Customer number.

If you wish to see other fields related to this customer,
you can either include them in the form's underlying
query, or place a subform with these fields, and link it
to the key field (Setting the properties Link Master
Fields and Link Child Fields).

Good luck.

Kevin Sprinkel
Becker & Frondorf
 
Back
Top