Runnung MS Access 2013, Windows 7.
I want to pass a form name as an openarg when opening a pop-up form, then access the recordsetclone of the passed form.
In the main form I call the pop-up as follows:
DoCmd.OpenForm "frmClientSearchResults", , , , , acDialog, Me.Name 'open the pop-up form
In the pop-up form one of the routines tries to do the following, but I'm getting a compile error "invalid use of property" on the second line (CallingForm = Me.OpenArgs)
Dim CallingForm As Form
CallingForm = Me.OpenArgs
.FindFirst "[client_id]=" & Me.client_id
If .NoMatch Then
MsgBox "Client not Found"
CallingForm.Section(0).Visible = True
CallingForm.Bookmark = .Bookmark
Can anyone help please?