How to bind a control to a tables value in designView -#Name?error

[ProgrammingB52]

Hi I just started out in design view with a form. I get a #Name? error on my form. What I want to do is have a text box be blank and when someone enters the data into the textbox I want it to be stored in a table. How do I bind the control to a table?

 

[PHV]

By setting its ControlSource property to the name of a field in the form's RecordSource.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ProgrammingB52]

Well I got that far but I am setting the control source wrong. I am setting it to =tableName!FieldName
That doesn't work.

 

[ProgrammingB52]

I managed to add an updated fieldlist to the form from the properties window. Then I can drag and drop the properties over. That makes them appear in the record source.