Linking control to table

[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

 

[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.

 

[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

 

[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.