If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form based on select query
Hi,
I have a form based on a select query which uses selected information from two tables; Clients and Claims. I need to add a couple of fields to the Claims table which I have done and I have also amended the query to include these fields, however, when I go to Field list on the Form to amend this part of the database, the new fields are not shown. Why is this? Thanks in advance. |
#2
|
|||
|
|||
Form based on select query
Hi, Gillian.
when I go to Field list on the Form to amend this part of the database, the new fields are not shown. Why is this? Check the form's Record Source Property. Does it name the query, or does it use a SQL statement? If it uses a SQL statement, you either need to change it to the name of the query or amend the SQL statement so that the new columns are included. After you change the Record Source Property, save the form and reopen the Field List. The new column names will be listed. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "GillianX" wrote in message ... Hi, I have a form based on a select query which uses selected information from two tables; Clients and Claims. I need to add a couple of fields to the Claims table which I have done and I have also amended the query to include these fields, however, when I go to Field list on the Form to amend this part of the database, the new fields are not shown. Why is this? Thanks in advance. |
#3
|
|||
|
|||
Form based on select query
Brilliant - thanks very much. Have a very Happy New Year!!!
"'69 Camaro" wrote: Hi, Gillian. when I go to Field list on the Form to amend this part of the database, the new fields are not shown. Why is this? Check the form's Record Source Property. Does it name the query, or does it use a SQL statement? If it uses a SQL statement, you either need to change it to the name of the query or amend the SQL statement so that the new columns are included. After you change the Record Source Property, save the form and reopen the Field List. The new column names will be listed. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "GillianX" wrote in message ... Hi, I have a form based on a select query which uses selected information from two tables; Clients and Claims. I need to add a couple of fields to the Claims table which I have done and I have also amended the query to include these fields, however, when I go to Field list on the Form to amend this part of the database, the new fields are not shown. Why is this? Thanks in advance. |
#4
|
|||
|
|||
Form based on select query
You're welcome! Happy New Year to you, too!
Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "GillianX" wrote in message ... Brilliant - thanks very much. Have a very Happy New Year!!! "'69 Camaro" wrote: Hi, Gillian. when I go to Field list on the Form to amend this part of the database, the new fields are not shown. Why is this? Check the form's Record Source Property. Does it name the query, or does it use a SQL statement? If it uses a SQL statement, you either need to change it to the name of the query or amend the SQL statement so that the new columns are included. After you change the Record Source Property, save the form and reopen the Field List. The new column names will be listed. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "GillianX" wrote in message ... Hi, I have a form based on a select query which uses selected information from two tables; Clients and Claims. I need to add a couple of fields to the Claims table which I have done and I have also amended the query to include these fields, however, when I go to Field list on the Form to amend this part of the database, the new fields are not shown. Why is this? Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|