Fields available on form?

[Rob]

I added a few new fields to a table.

When I'm in a form in design mode, trying to bind a field in that table to a textbox,I right-click on the textbox, click Properties, Data, and then choose the field from the drop-down list "Control Source".

After adding the fields to the table, they don't show up in the "Control Source" list. If I enter the field manually, I get a #name! error. If I create a form after adding the fields to the table, the new form has the fields available, but not any existing forms.

I've tried using the Expression Builder, but I don't get the list of fields there either.
Any suggestions?

 

[Travis]

Is the forms RecordSource the Table or a Query? If it is a query then you will need to add the fields to the query.

 

[R. Hicks]

If the form's control source is set to a query, then you need to add the field to the query. Adding a new field to the table will not automatically be added to the query unless you used the (*), which tells Access to select all fields.

HTH
RDH

 

[R. Hicks]

Sorry Travis, you were quicker to the draw than I.

RDH