Linking Two Subforms

[Mike Boozer]

I have two subforms on my main form. I want the records on subform B
to correspond with the records on subform A which they do. However,
I want the records on subform A to let me know if there is a
corresponding record on subform B without having to go to subform B
to see for myself. Take a look at the screenshots of what I am
trying to accomplish at http://www.chemreport/test/helpme.htm

Main Form = ChemicalInventory w Primary IDPartNo
Subform A = EditSuppliers w Primary IDSupplier & Foreign IDPartNo
Subform B = MSDSDocs w Primary IDMSDS & Foreign IDPartNo & Foreign
IDSupplier

The code on sfMSDSDocs oncurrent event is:

Forms![ChemicalInventory].[EditSuppliers].Form! _
imgRedDot.Visible = IsNull(Me.LocalScanLink)

Forms![ChemicalInventory].[EditSuppliers].Form! _
imgGreenDot.Visible = Not IsNull(Me.LocalScanLink)

Can this be done? I am a novice with little syntax so I need help
with code if this can work. Thanks group.

[Bob Quintal]

"Mike Boozer" <mb*****@wi.rr.com> wrote in
news:0p****************@tornado.rdc-kc.rr.com:

I have two subforms on my main form. I want the records on
subform B to correspond with the records on subform A which
they do. However, I want the records on subform A to let me
know if there is a corresponding record on subform B without
having to go to subform B to see for myself. Take a look at
the screenshots of what I am trying to accomplish at
http://www.chemreport/test/helpme.htm

Main Form = ChemicalInventory w Primary IDPartNo
Subform A = EditSuppliers w Primary IDSupplier & Foreign
IDPartNo Subform B = MSDSDocs w Primary IDMSDS & Foreign
IDPartNo & Foreign IDSupplier

The code on sfMSDSDocs oncurrent event is:

Forms![ChemicalInventory].[EditSuppliers].Form! _
imgRedDot.Visible = IsNull(Me.LocalScanLink)

Forms![ChemicalInventory].[EditSuppliers].Form! _
imgGreenDot.Visible = Not IsNull(Me.LocalScanLink)

Can this be done? I am a novice with little syntax so I need
help with code if this can work. Thanks group.

To synchronze the two forms, the easy way is to use the built-in
Access parent-child linking. This means that each subform's keys
need to appear on the parent form so that the other subform can
see them. They can be visible=no, it still works.

The trick is to set the values of each textbox in the Current
event of the corresponding subform.

In your case, if I read you correctly, the
EditSuppliers_On_Current event would contain statements to set
parent!txtIdSupplier = me!idSupplier
The linkparentfields property of the ChemicalInventory subform
would contain Idpartno,txtIDSupplier and the child fields
IDPartNo,IDSupplier

Access sees the change in the textbox and resets the subform to
match.

--
Bob Quintal

PA is y I've altered my email address.

[Tom van Stiphout]

On Sat, 03 Dec 2005 14:47:42 GMT, Bob Quintal <rq******@sympatico.ca>
wrote:

Or you can use an expression in the parent form control's
ControlSource property:
= SomeSubformControl.Form.SomeControl

-Tom.
<clip>

In your case, if I read you correctly, the
EditSuppliers_On_Current event would contain statements to set
parent!txtIdSupplier = me!idSupplier

<clip>