I have several tables, and several forms (with one main form), each form has its own table. All of those forms/tables keep information about a single project so I need to be able to display the same project when a user goes from one form to another. I am trying to control the recordsource property of each form to display the record id that is coming from the main form. I've tried everything from putting the id on the main form(which is auto generated) in a variable so that I can then use an SQL statement in my other forms to bring the id that matches the main form.
Anyways to keep it short, when I do
SELECT * FROM SECTIONV.RecordID WHERE = 'recToGo';
it always says error 2001 "You cancelled the previous operation".
I just cannot seem to get it to select the record that I want it to based on what the variable recGoTo contains.
If I take out the single quotes it will ask me for the parameter value of recToGo then it will go to the right record.
Any help would be greatly appricated because this is driving me nuts!