Linking tables

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Have built a data base.
Wish to add a form which contains a series of Drop down
boxes.
Cannot get the info to be retained in respective Customer
Fields.
Each time I open a new client page the data entered is not
retained.
Any suggestions please

regards

Barry
 
Barry,

The key concepts here are that the form needs to be based on the table
(or query), in other words the Record Source property of the form will
be the table (or query). And then the controls on the form (text boxes,
combob boxes, etc) need to be bound to the applicable fields in the
form's underlying table/query, in other words the Control Source
property of the controls will show the name of the field. The first
thing to check is that these are set up correctly.
 
Back
Top