View Full Version : Fields available on form?


Rob
05-23-2000, 09:23 AM
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
05-23-2000, 12:24 PM
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
05-23-2000, 12:26 PM
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
05-23-2000, 12:28 PM
Sorry Travis, you were quicker to the draw than I.

RDH