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
|
|||
|
|||
Adding controls to a subform
Okay, here's the problem.
I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#2
|
|||
|
|||
Adding controls to a subform
If the data comes from more than one table, then the record source of the
form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#3
|
|||
|
|||
Adding controls to a subform
Aha - that makes sense.
Can you tell me where to edit the SQL? I'm new to Access, forms and such. Cheers dude, Mort "Brendan Reynolds" wrote: If the data comes from more than one table, then the record source of the form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#4
|
|||
|
|||
Adding controls to a subform
I should add that when I click on the "view button" I don't get the SQL View
option, just design, form, datasheet and pivot Cheers "Mort" wrote: Aha - that makes sense. Can you tell me where to edit the SQL? I'm new to Access, forms and such. Cheers dude, Mort "Brendan Reynolds" wrote: If the data comes from more than one table, then the record source of the form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#5
|
|||
|
|||
Adding controls to a subform
Open the form (the one that is used as a subform, not the main form) in
design view. If the Properties window is not visible, select Properties from the View menu. If the Properties window is showing the properties of one of the controls on the form rather than the properties of the form itself, choose Select Form from the Edit menu. Select the Data tab in the Properties window. Click in the Record Source field in the Properties window, then click the builder button - the one with the ellipsis (...) - which appears to the right of the Record Source field. -- Brendan Reynolds "Mort" wrote in message ... Aha - that makes sense. Can you tell me where to edit the SQL? I'm new to Access, forms and such. Cheers dude, Mort "Brendan Reynolds" wrote: If the data comes from more than one table, then the record source of the form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#6
|
|||
|
|||
Adding controls to a subform
I'm an idiot - i see what you mean now. My problem is that the form (and
subform) are getting their data directly from the two tables - not through a query. It's almost as if the form is running a hidden query to get the data, as anything new added to the table cannot be referenced referenced in the form. What do you think? "Brendan Reynolds" wrote: If the data comes from more than one table, then the record source of the form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#7
|
|||
|
|||
Adding controls to a subform
Perfect - so as long as the form gets the data from the query and not
directly from the tables, the form can display everything. Nice one dude - I really appreciate your help. All the best, Mort "Brendan Reynolds" wrote: Open the form (the one that is used as a subform, not the main form) in design view. If the Properties window is not visible, select Properties from the View menu. If the Properties window is showing the properties of one of the controls on the form rather than the properties of the form itself, choose Select Form from the Edit menu. Select the Data tab in the Properties window. Click in the Record Source field in the Properties window, then click the builder button - the one with the ellipsis (...) - which appears to the right of the Record Source field. -- Brendan Reynolds "Mort" wrote in message ... Aha - that makes sense. Can you tell me where to edit the SQL? I'm new to Access, forms and such. Cheers dude, Mort "Brendan Reynolds" wrote: If the data comes from more than one table, then the record source of the form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#8
|
|||
|
|||
Adding controls to a subform
I'm sorry, I'm afraid you lost me there. What is the Record Source of the
main form? What is the Record Source of the subform? And to which table did you add the new field? -- Brendan Reynolds "Mort" wrote in message ... I'm an idiot - i see what you mean now. My problem is that the form (and subform) are getting their data directly from the two tables - not through a query. It's almost as if the form is running a hidden query to get the data, as anything new added to the table cannot be referenced referenced in the form. What do you think? "Brendan Reynolds" wrote: If the data comes from more than one table, then the record source of the form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
#9
|
|||
|
|||
Adding controls to a subform
The record source for the main form was the main table (with links to a
second table). Not to worry now, changing the source to a query has solved the problem. Thanks again. "Brendan Reynolds" wrote: I'm sorry, I'm afraid you lost me there. What is the Record Source of the main form? What is the Record Source of the subform? And to which table did you add the new field? -- Brendan Reynolds "Mort" wrote in message ... I'm an idiot - i see what you mean now. My problem is that the form (and subform) are getting their data directly from the two tables - not through a query. It's almost as if the form is running a hidden query to get the data, as anything new added to the table cannot be referenced referenced in the form. What do you think? "Brendan Reynolds" wrote: If the data comes from more than one table, then the record source of the form must be either a SQL statement or the name of a saved query that joins those two tables. You will need to add the new field to the SQL statement or query before it becomes visible to the form. -- Brendan Reynolds "Mort" wrote in message ... Okay, here's the problem. I've a form which contains a subform that gets data from two tables. Everything was fine until i needed to add a new field to the one of the tables. Now, the data is fine but i can't add a check box for the new data field - after clicking on properties and then data then control source, the newly added field in the table does not appear in the list. What do you think? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding record to subform | Someone | General Discussion | 8 | November 28th, 2005 12:21 AM |
Accessing (!) subform controls properties at runtime | AlexT | Using Forms | 4 | November 9th, 2005 09:55 AM |
Form data to automatically upldate a field in the subform | Database User | Using Forms | 6 | November 8th, 2005 09:01 PM |
Adding from Subform to Subform | north-bc | Using Forms | 2 | January 3rd, 2005 09:15 PM |
Very Newbie: Adding field to subform | Bill Craig | Using Forms | 2 | June 24th, 2004 05:07 PM |