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
|
|||
|
|||
another subform question
Hi,
My main form is based on a table. The subform is based on another related table and they have a 1-many relationship. When I change the client number in the mainform, the client number in the subform doesn't change. Also, when I go through the records on the subform, I get other clients, not just the one I had in the main form. What is it that I am doing wrong? It seems like it should be simple, but I am obviously missing or not understanding something about these. Any hints? Oh, and both of the tables are 'updateable' snapshots. thanks! |
#2
|
|||
|
|||
another subform question
On Thu, 9 Nov 2006 15:27:01 -0800, Maggie
wrote: Hi, My main form is based on a table. The subform is based on another related table and they have a 1-many relationship. When I change the client number in the mainform, the client number in the subform doesn't change. Also, when I go through the records on the subform, I get other clients, not just the one I had in the main form. What is it that I am doing wrong? It seems like it should be simple, but I am obviously missing or not understanding something about these. Any hints? Oh, and both of the tables are 'updateable' snapshots. thanks! What's probably missing is the Master Link Field and Child Link Field properties of the Subform control. They should contain the linking field (ClientNumber I'd assume). The subform will not (and should not!!!) update the client number in the subform's records when you change it! John W. Vinson[MVP] |
#3
|
|||
|
|||
another subform question
Hello Maggie,
Agree with John and you may want to see the following article for details: 304276 ACC2002: Working with Subdatasheets in Microsoft Access http://support.microsoft.com/default...b;EN-US;304276 Also, please check Orders form in sample Northwind database which usually meets common requirements. If you did not install it, you could click Help-Sample database-Northwind sample database to install it. If you have any further comments or questions, please let's know. Thank you. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif ications http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
#4
|
|||
|
|||
another subform question
Thanks Peter. I ended up creating a nother subform because I couldn't get
the first one I made working. I probably did something wrong. Anyway it works. I have to hit enter in order for the subform to be synchronized with the main form. Maybe I'll try to do that programmatically instead of hitting enter. thanks for your help. Maggie "Maggie" wrote: Hi, My main form is based on a table. The subform is based on another related table and they have a 1-many relationship. When I change the client number in the mainform, the client number in the subform doesn't change. Also, when I go through the records on the subform, I get other clients, not just the one I had in the main form. What is it that I am doing wrong? It seems like it should be simple, but I am obviously missing or not understanding something about these. Any hints? Oh, and both of the tables are 'updateable' snapshots. thanks! |
#5
|
|||
|
|||
another subform question
thanks John, that was it
"Maggie" wrote: Hi, My main form is based on a table. The subform is based on another related table and they have a 1-many relationship. When I change the client number in the mainform, the client number in the subform doesn't change. Also, when I go through the records on the subform, I get other clients, not just the one I had in the main form. What is it that I am doing wrong? It seems like it should be simple, but I am obviously missing or not understanding something about these. Any hints? Oh, and both of the tables are 'updateable' snapshots. thanks! |
Thread Tools | |
Display Modes | |
|
|