Programming text boxes

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

I have a form that is used to enter/update/delete
information for each customer. Some customers have more
than one location associated with them. Is it possible to
have only the locations associated with a specific
customer_id to be displayed in the location box? If so,
what would my code look like??? Thanks for any information
that can be provided.
 
Judging from your wording of your question your knowledge
of Access, the best way for you to do this is using
a "Subform". Put your customer locations in a separate
table from the general customer data, make the first field
identical to the identifier field of the customer table
(ID, CustNo, etc.), but don't make it the key field. Add
another field like LocationID (int type) and make BOTH the
ID and the LocationID field they key. Make a datasheet
type form form the locations table. design the customer
form. drag the locations form from the database window
and drop it on the customer form. in the properties of
the locations form withing the customer form, set the
Master link field to the unique identifier for the
customer table, and the Child like field to the identifier
for the location table.

long story, but it works.
 
Back
Top