Question about adding a field to a query/form

  • Thread starter Thread starter King Kaos
  • Start date Start date
K

King Kaos

I have two table that make a query, and a form based on the query. I added
a field to a table (one that is not linked to anything in the second table),
then added it to the query - but when I go to the form - it does not provide
the field in the field list. what am I doing wrong.

Keith
 
I have two table that make a query, and a form based on the query. I added
a field to a table (one that is not linked to anything in the second table),
then added it to the query - but when I go to the form - it does not provide
the field in the field list. what am I doing wrong.

Keith
Click to expand...

Open the Form in design view; view its Properties; and check the
RecordSource property. It might not know about the new field. Click
the ... icon by it to open a query design window, where you'll be able
to add the field.

John W. Vinson[MVP]
 
In the query under 'Show', if you uncheck this box the field will not show up
in the field list.
 
Back
Top