Synchronize two forms.

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hello =)
I want to synchronize a form (Form1) and another form that
is a subform (sfrmMeasurementDevices) from frmMD.
Form1 is a short overview for Measurement devices. and
sfrmMeasurementDevices shows detail information and other
stuff.
I wanted to synchronize useing MDID
part of the code looks like follows:
Dim rst As DAO.Recordset
Dim strSearch As String
Forms!frmMD!sfrmMeasurementDevices.RecordsetClone
strSearch = BuildCriteria("MDID", dbLong, Me!MDID)
rst.FindFirst strSearch
Forms!frmMD!sfrmMeasurementDevices.Bookmark =
rst.Bookmark
The code is placed on Form1. And an error is generated on
Forms!frmMD!sfrmMeasurementDevices.RecordsetClone --
"Object doesn't support property or method"
Click to expand...

There's no Child-Master link between frmMD and
sfrmMeasurementDevices (and for my purposes it must be
like this). sfrmMeasurementDevices RecordSource is
assigned on its load event.

thx.
 
Well, I don't see where you are setting the recordset variable, and you are
not doing anything with the RecordsetClone line. I'm guessing you want to
set the recordset variable to the RecordsetClone, in which case you might
try this:

set rst = Forms!frmMD!sfrmMeasurementDevices.RecordsetClone
 
ups Yes sorry it's exactly like that

Set rst = Forms!frmMD!sfrmMeasurementDevices.RecordsetClone
and there's where the error raises =/
 
Back
Top