Field list not updating

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

Guest

I have added some new tables in my database. When I am in design mode on a form, the new fields do not show up in the field list?
 
The reason for new fields added to a table not showing up in the form's
field list is usually that the Record Source for the form is a query of the
table. Add the new fields to the query and you will see them in the field
list in your form's design view.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Kirk said:
I have added some new tables in my database. When I am in design mode on a
Click to expand...
form, the new fields do not show up in the field list?
 
I have not created any queries yet. Just tables and one form, which will be used for data entry.

Thanks,

Kirk

----- Cheryl Fischer wrote: -----

The reason for new fields added to a table not showing up in the form's
field list is usually that the Record Source for the form is a query of the
table. Add the new fields to the query and you will see them in the field
list in your form's design view.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Kirk said:
I have added some new tables in my database. When I am in design mode on a
Click to expand...
form, the new fields do not show up in the field list?
 
So what is the name of the recordsource property? Just
the table name?

Then close the form, and reopen it.

If it's a SELECT clause, change it to say Select * from
Table1.


Chris Nebinger

-----Original Message-----
I have not created any queries yet. Just tables and one
Click to expand...
form, which will be used for data entry.
 
Back
Top