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!

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]

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.

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!

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!