Hi all,
I have a main form sub form. However I do not populate the subform until the main form is open. i.e. in the Form Load (of the Main Form) I set 'RecordSource' of the subform.
I would like to open the form and have the subform go to a specific record.
I have tried:
I checked and the
is true.
Any ideas?
I appreciate any help you can give me with this,
Thank you,
I have a main form sub form. However I do not populate the subform until the main form is open. i.e. in the Form Load (of the Main Form) I set 'RecordSource' of the subform.
I would like to open the form and have the subform go to a specific record.
I have tried:
Code:
Dim rs As Object
Set rs = Me.sfrm_Common.Form.Recordset.Clone
rs.FindFirst "[dt_Date] = " & Trim(Str(DLookup("dt_Current", "tbl_Stored_Date")))
If Not rs.EOF Then Me.sfrm_Common.Form.Bookmark = rs.Bookmark
I checked and the
Code:
Not rs.EOF
Any ideas?
I appreciate any help you can give me with this,
Thank you,