Fields not on form after ammending query

R

Ronnie

I have added 4 new fields to a query which I had previously defined. I had already created a form based upon the query. The problem is the 4 new fields does not appear in the field list when in design view of the form. Is there a way to simply add the four new fields to the form without me having to recreate the form.
 
S

Steve Schapel

Ronnie,

Normally I would expect the fields that you have added to the query
would be available from the form's Field List. Can you make 100% sure
that this query is indeed the Record Source of the form. And also check
the design of the query, that the Show checkbox is ticked for the newly
added fields.
 
R

Ronnie

Thanks for the reply Steve. I only have 2 query's in my database so I know it was the correct query which I had updated. The show option was also ticked on the query design grid of the fields I had added. Still no joy. Recreated forms again to solve problem

Thanks Again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top