Field views not showing up on Control source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok this is too easy I must be overlooking something.

Created a form via first wizard then edit via design mode.

Two tables are connected to the form.

I added more fields to table #2.

When I add combo boxes to the form, the control source drop down does not
show the new fields added to the table.

I racked my brains on this cannot find how to populate the new fields on the
table to the control source drop down.
 
ssciarrino said:
Ok this is too easy I must be overlooking something.

Created a form via first wizard then edit via design mode.

Two tables are connected to the form.

I added more fields to table #2.

When I add combo boxes to the form, the control source drop down does
not show the new fields added to the table.

I racked my brains on this cannot find how to populate the new fields
on the table to the control source drop down.
Click to expand...

The wizard usually doesn't bind the form to the table, but rather to a SQL
statement pulling data from the table. That SQL statement will not pick up
new fields added to the table unless you edit it to include them. If you
change the RecordSource property of the form to simply the name of your
table then new fields will be picked up automatically after that.
 
ssciarrino said:
Rick can you direct where I can locate the RecordSource?
Click to expand...

Open Form in design view, open property sheet, go to Data tab. First
property at the top.
 
Back
Top