set control value = to subform control value

  • Thread starter Thread starter soundstream11
  • Start date Start date
S

soundstream11

I am trying to take a value from a control on a subform and post it to
a control on the main form before update.

Here is what i have:
(access 2000)

tblOne: SampleNumber,LinkNumber,LinkSchedule (and other misc)

tblTwo: EmpID,LinkNumber,LinkSchedule (and other misc)

frmOne recordsource = tblOne
subfrmTwo recordsource = tblTwo

When i enter a LinkNumber in frmOne, it filters all of the records in
subfrmTwo with the matching LinkNumber. LinkSchedules will be
different, so there will be multiple entries with the same LinkNumber
in tblTwo. After i enter a LinkSchedule in subfrmTwo, i would like it
to update tblOne.LinkSchedule.

Any thoughts or suggestions?
 
soundstream11 said:
I am trying to take a value from a control on a subform and post it to
a control on the main form before update.

Here is what i have:
(access 2000)

tblOne: SampleNumber,LinkNumber,LinkSchedule (and other misc)

tblTwo: EmpID,LinkNumber,LinkSchedule (and other misc)

frmOne recordsource = tblOne
subfrmTwo recordsource = tblTwo

When i enter a LinkNumber in frmOne, it filters all of the records in
subfrmTwo with the matching LinkNumber. LinkSchedules will be
different, so there will be multiple entries with the same LinkNumber
in tblTwo. After i enter a LinkSchedule in subfrmTwo, i would like it
to update tblOne.LinkSchedule.
Click to expand...

Not sure I understand exactly what you want, but you can use
a line of code in the LinkSchedules text box AfterUpdate
event:

Me.Parent.txtLinkSchedule = Me.txtLinkSchedule

where txtLinkSchedule is a text box bound to the
LinkSchedule field.

BUT, you said that the subform is linked on the LinkNumber
field. If so, what does it mean to set the main table's
LinkSchedule field? Further more, why is the LinkSchedule
field in the main tableat all??
 
Back
Top