Linking control to table

F

Fran

I have created a form without linking these controls to
my table. Now I want to bind these controls to the table.
Am I still able to do this now?
I have gone to the control source in the property sheet
and clicked on the down arrow, nothing is listed here. Do
I just type in =[tblTableName].FieldName to link to the
table?. What is the next step.
Thanks
Fran
 
D

Douglas J. Steele

Have you indicated a RecordSource for the form? You can only bind controls
if they're contained in the form's RecordSource. Once you've got a
RecordSource, you bind the control to the specific field by setting the
control's ControlSource property.
 
N

Nikos Yannacopoulos

Fran,

Go to the form's Record Source property (on the Data tab) and type in the
name of the table you want to bind it to (or invoke the query builder to use
a query, or just type the name of an already saved query). This done, the
names of the fields will appear in the drop-down list in the Control Source
property of each individual control.

HTH,
Nikos
 
S

StCyrM

Good morning Fran

You will have to supply a RecordSource for your form. To do this, simply look
at the properties sheet and select a record source ( 1st item in the list )

Then for each of your text boxes, you will then have to assign it to a Control
Source

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Top