Question about adding a field to a query/form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

King Kaos - 30 Jan 2005 05:54 GMT

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

Reply to this Message

John Vinson - 30 Jan 2005 06:57 GMT

>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]

Reply to this Message

Beeker - 31 Jan 2005 18:17 GMT

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

> 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

Reply to this Message