Today seems to be a VBA kind of day.
I have a process that clones a recordset then prompts the user to name the newly create clone via an Inputbox.
I then typically use a combobox populated with the name of the original and all clones to navigate to each record. I however want to add in the code that after the clone is created, go to that record. This is to prevent the user from think the form is on the newly created clone, when it is in fact not until they select it in the combo.
I have the user value from the Inputbox as strinput.
I tried:
But that failed.
What did a mess up on?
I have a process that clones a recordset then prompts the user to name the newly create clone via an Inputbox.
I then typically use a combobox populated with the name of the original and all clones to navigate to each record. I however want to add in the code that after the clone is created, go to that record. This is to prevent the user from think the form is on the newly created clone, when it is in fact not until they select it in the combo.
I have the user value from the Inputbox as strinput.
I tried:
Code:
DoCmd.GoToRecord acDataForm, "JobQuote", acGoTo = "[RevisionName] = '" & strinput & "'"
What did a mess up on?