Field List Update: Form Based on Query

D

DianaS

Hello,

I have created a form based on a query. I updated the query so that it
could include additional fields. However, the field-list button (clicked in
the form's design view) does not show the additional fields. How can I get
the Field List to update? Thank you. I appreciate the help! :)

Diana
 
O

Ofer

Look at the RecordSource Property of the form to see if its includes the new
field you created.
 
6

'69 Camaro

Hi, Diana.
How can I get
the Field List to update?
Click to expand...

The Form's Field List is based upon the fields in the Form's RecordSource
Property. Since you have based the form on a SQL statement instead of bound
it to a saved query, updating the saved query with additional fields won't
automatically change the Form's RecordSource Property. To make this Field
List automatic, you need to open the Form in Design View, then select the
"Data" tab in the Form's Properties dialog window, then select the name of
the saved query to replace the SQL statement saved in the Form's RecordSource
Property.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are [email protected] and [email protected]

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
D

DianaS

Hello,

What you say makes sense. The only problem is that the Data tab under the
form's properties is blank. (In Access 2000, I opened the form in design
view, and then under "View" from the menu bar selected Properties.) Is there
an alternate way to change the record source?

Thank you,
Diana
 
D

DianaS

Hi,

I solved the problem--just went into the original query and manually added
the field that I needed. I appreciate your help though. Thank you very much.

Diana
 
Top