jgoodman00
Programmer
- Jan 23, 2001
- 1,510
If so how, because there is much debate over this here....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
can you add new fields to the recordsource of a form?? 1
- Thread starter jgoodman00
- Start date
- Status
-
1
- #2
- Thread starter
- #3
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
By recordsource i mean the fieldlist which you can reference into any given control under control source. I only ask this, because we regularly add fields to our source tables, & these don't show in the field list, so adding these fields can become a real palavar... James Goodman
j.goodman00@btinternet.com
j.goodman00@btinternet.com
- Thread starter
- #4
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
I have just done it actually. For some reason I have managed to go all this time without realising you can add fields to the fieldlisting by changing the sql statement (to which i presume you were referring) under recordsource in the form properties......D'Oh!!!! James Goodman
j.goodman00@btinternet.com
j.goodman00@btinternet.com
OK, what is the recordsource of your form? the field list is based on that. That's why I said that you will need to modify your form's recordsource.
You can create a query which contains all the fields in all the tables, no matter if you add fields, by using the asterisk from the top of the field list in query design.
If you have three tables that are the basis of your form, create a query, add all three tables and drag the links between them, if you haven't already set up relationships.
then for each field, doubleclick on the asterisk which is listed at the top of the field list of each table. That tells the query to get all the fields. Make this query the recordsource of your form.
If you add fields, they will automatically be added to the query, and therefore will be part of your recordsource, and therefore will be available in the field list.
I hope that I understood your question.
Kathryn
You can create a query which contains all the fields in all the tables, no matter if you add fields, by using the asterisk from the top of the field list in query design.
If you have three tables that are the basis of your form, create a query, add all three tables and drag the links between them, if you haven't already set up relationships.
then for each field, doubleclick on the asterisk which is listed at the top of the field list of each table. That tells the query to get all the fields. Make this query the recordsource of your form.
If you add fields, they will automatically be added to the query, and therefore will be part of your recordsource, and therefore will be available in the field list.
I hope that I understood your question.
Kathryn
- Thread starter
- #6
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
Yes you did, & directed my attention to a field i have never actually noticed before.As I said before.....D'Oh!! James Goodman
j.goodman00@btinternet.com
j.goodman00@btinternet.com
- Status
Similar threads