how do I get the field value from main form to subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've designed main form and subform with masterlink/childlink one to many
relationship and I have field "title" on main form also "title" field on the
subform. I want to auto entry subform "title" every time I enter the subform
CONDITIONALLY such Product ID# in main form= Product ID# in but don't know how

Please help
 
CGM said:
I've designed main form and subform with masterlink/childlink one to
many relationship and I have field "title" on main form also "title"
field on the subform. I want to auto entry subform "title" every
time I enter the subform CONDITIONALLY such Product ID# in main form=
Product ID# in but don't know how

Please help
Click to expand...

Add it to the MasterLink ChildLink properties.
 
On Tue, 26 Jul 2005 15:40:01 -0700, "CGM NEWBIE" <CGM
I've designed main form and subform with masterlink/childlink one to many
relationship and I have field "title" on main form also "title" field on the
subform. I want to auto entry subform "title" every time I enter the subform
CONDITIONALLY such Product ID# in main form= Product ID# in but don't know how

Please help
Click to expand...

I must ask... WHY?

Are you attempting to store the title redundantly in the subform's
recordsource table? If so, you shouldn't!

Do you want to just *see* the title, or store it? If you just want to
see it, a Combo Box bound to the ProductID but displaying the title
might be suitable; or you could use an unbound textbox with

=DLookUp("[title]", "[maintable]", "[ProductID] = " & [ProductID])

as a control source.

John W. Vinson[MVP]
 
Back
Top