I am trying to set a form's Recordsource with a macro.
Based on the user's input on an input form, clicking a button opens a 2nd form whose recordsource is determined by in the input of the 1st form.
I have a macro that basically says, if checkbox1 value is -1, setvalue of Forms!Form.Recordsource, Expression "Query1". When I run the macro I get a type mismatch error. Even though the HELP states that Strings should be enclosed with "", I think this is what Access is erroring me on...??
What is wrong? and is there some other way I should accomplish this?
Thanks!
Based on the user's input on an input form, clicking a button opens a 2nd form whose recordsource is determined by in the input of the 1st form.
I have a macro that basically says, if checkbox1 value is -1, setvalue of Forms!Form.Recordsource, Expression "Query1". When I run the macro I get a type mismatch error. Even though the HELP states that Strings should be enclosed with "", I think this is what Access is erroring me on...??
What is wrong? and is there some other way I should accomplish this?
Thanks!