Combo boxes and sub form

[Erik Gjertsen]

I Have synchronize two Combo Boxes. That is going good. But I try to set inn
a subform I got problem.

The fist combo boxes name is master and the second is slave.
The name of the forms is LinkFRM.

SELECT IdentTBL.IdentID, IdentTBL.Fornavn, IdentTBL.Etternavn,
IdentTBL.TkNr, TkTBL.Tknavn, IdentTBL.Telefon, IdentTBL.Mobil
FROM TkTBL INNER JOIN IdentTBL ON TkTBL.TkNr = IdentTBL.TkNr;

I use followed procedure:


Private Sub slave_AfterUpdate()
Me.RecordsetClone.FindFirst "[TkNr]=" & Me![slave]
Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub

And I got following error masages:
Runtime Error 7951
You entered an expression that has an invalid reference to the
RecordsetClone property.

Can someone help me??

Thanks
Erik Gjertsen

 

[Edward Lillis]

The form must have a Record Source.

ed

 

[Erik Gjertsen]

I have use following query in the second combo boxes
SELECT TkTBL.TkNr, TkTBL.Tknavn, TkTBL.FTKID
FROM TkTBL
WHERE (((TkTBL.FTKID)=[Forms]![LinkFRM]![master]))
ORDER BY TkTBL.TkNr;

The form must have a Record Source.

ed

I Have synchronize two Combo Boxes. That is going good. But I try to set inn
a subform I got problem.

The fist combo boxes name is master and the second is slave.
The name of the forms is LinkFRM.

SELECT IdentTBL.IdentID, IdentTBL.Fornavn, IdentTBL.Etternavn,
IdentTBL.TkNr, TkTBL.Tknavn, IdentTBL.Telefon, IdentTBL.Mobil
FROM TkTBL INNER JOIN IdentTBL ON TkTBL.TkNr = IdentTBL.TkNr;

I use followed procedure:


Private Sub slave_AfterUpdate()
Me.RecordsetClone.FindFirst "[TkNr]=" & Me![slave]
Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub

And I got following error masages:
Runtime Error 7951
You entered an expression that has an invalid reference to the
RecordsetClone property.

Can someone help me??

Thanks
Erik Gjertsen