D
Dan
Hi - I am using the code below to programmatically find a record in a subform
having a Datasheet configuration based on a value on the main form. It works
fine, but is there a way that I can make it select the whole record instead
just the field it found?
'***********************
Dim rs As Object
Set rs = Forms!frmMain!fsubContext.Form.Recordset.Clone
rs.FindFirst "[Zip] = '" & Forms!frmMain![Zip] & "'"
Forms!frmMain!fsubContext.Form.Bookmark = rs.Bookmark
'***********************
Thanks so much for any ideas!
Dan
having a Datasheet configuration based on a value on the main form. It works
fine, but is there a way that I can make it select the whole record instead
just the field it found?
'***********************
Dim rs As Object
Set rs = Forms!frmMain!fsubContext.Form.Recordset.Clone
rs.FindFirst "[Zip] = '" & Forms!frmMain![Zip] & "'"
Forms!frmMain!fsubContext.Form.Bookmark = rs.Bookmark
'***********************
Thanks so much for any ideas!
Dan