By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,481 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,481 IT Pros & Developers. It's quick & easy.

Can't see field in field list

P: 3
Hi,

After creating all my tables, forms, and queries... I entered some sample data for testing... all was working... at the last minute I decided to add a text field in one of my tables. When I went back to add the new field into one of the forms that uses the table the field list box did not have listed the new field I just added to the table. I'm puzzled. I need to add the new field to the form.
Oct 10 '06 #1
Share this Question
Share on Google+
2 Replies


P: 48
Hi,

After creating all my tables, forms, and queries... I entered some sample data for testing... all was working... at the last minute I decided to add a text field in one of my tables. When I went back to add the new field into one of the forms that uses the table the field list box did not have listed the new field I just added to the table. I'm puzzled. I need to add the new field to the form.
Does the formsource (form->properties->recordsource) show a SQL-instruction? If so, enter the query and add the desired field to the query. Then go back to the form and the field should be visible when you choose your textfield recordsource.

Sander
Oct 11 '06 #2

P: 3
Does the formsource (form->properties->recordsource) show a SQL-instruction? If so, enter the query and add the desired field to the query. Then go back to the form and the field should be visible when you choose your textfield recordsource.

Sander
That did it!!! Thanks so much.
Oct 11 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.