Question about adding a field to a query/form

[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

 

[John Vinson]

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

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]

 

[Beeker]

In the query under 'Show', if you uncheck this box the field will not show up
in the field list.