let procedure and get procedure error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On the click of a button on one form another 2 forms are opened with the
original staying open. I am using the following code
stDocName = "NewFormName"
stLinkCriteria = "[CardNo] = [forms]![CurrentFormName]![CardNo]"
DoCmd.OpenForm stDocName, , , stLinkCriteria
to open the new form and similar to open the other form and the code
[Forms]![NewFormName]![fieldName]!SetFocus = True
to place the cursor in the field [fieldname] on the form NewFormName.
The cursor goes to the correct place but I get the message 'Property let
procedure not defined and property get procedure didnot return an object.'

Any ideas why the error message appears?
 
Instead of
[Forms]![NewFormName]![fieldName]!SetFocus = True
use
[Forms]![NewFormName]![fieldName].SetFocus

This assumes that NewFormName already has the focus.
 
Back
Top