Allen Browne's Return to the same record

A

Anne

I have used Allen Browne's routine in another database and it works. I added
it to a form in another database and I can't get it to work.

When opening the FrmCustomer, I get the run-time error 2001. You cancelled
the previous operation. On clicking debut it takes me to the line:
varID = DLookup("Value", "tblSys", "[Variable] = 'CustomerIDLast'") and it
shows me the varID =empty.

It is correct, it never put anything into the tblsys.

When I reopen the form, select a customer and exit, I get: Run-time error
3265, item not found in this collection. It cannot find the customerID.

I just don't know what I am looking for. The form is the main form and is
based on tblCustomer and the primary ID is CustomerID.
I even copied the Loan and Unload directly from the website.
I have not missing references.
Help, why could this be happening?
Anne
 
A

Anne

I just found my own answer. I deleted my tblsys and imported the tblsys from
the other database.
I did not see anything wrong with the new table, but apparently something
was not set corrrectly.
Anne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allen Browne's Recurring events 0
open to same record as when form was closed last 6
Allen Browne's FindAsUType module 10
Allen Browne's MultiForms 2
Allen Browne's audit table 1
Allen Browne's Duplicate Record Code 7
Allen Browne's 'Library Resource' 8
Allen Browne - Find as you type - Can I print the results 1

Top