I've got an Access 2000 ADP with an SQL 7 backend.
My problem is this..
When moving from a record in one form to another record in a different form it opens the other from but doesn’t always go to the specific record.
It works fine about 25% of the time and when run through the debugger it worked fine every time.
I can't use a filter, as the form needs the versatility of looking through all the records.
I'm using a global variable.
I declare the variable as the primary key on one form.
Test to see if the other form is already open, if it isn't then it opens it. Then in the On Load event of that form it performs the find. (if Varible <>0 then DoCmd.FindRecord variable)
If it's open it just switches focus and does the find itself, this works 100% of the time.
My problem is this..
When moving from a record in one form to another record in a different form it opens the other from but doesn’t always go to the specific record.
It works fine about 25% of the time and when run through the debugger it worked fine every time.
I can't use a filter, as the form needs the versatility of looking through all the records.
I'm using a global variable.
I declare the variable as the primary key on one form.
Test to see if the other form is already open, if it isn't then it opens it. Then in the On Load event of that form it performs the find. (if Varible <>0 then DoCmd.FindRecord variable)
If it's open it just switches focus and does the find itself, this works 100% of the time.