Problem with Text Box to Open Another form to display a record

[Mark Nash]

Can anyone help? I'm clearly an amateur and know next to no VBA or SQL. The problem occurs with a main form, with many records, and I have a text box to open another form to view the full details of the current record. It works, and then when I shut down the DB and go back in, I get the below, which then errors when I click, with a box Return without GoSub, and a subsequent macro sing step stop all macros box.


The form design looks like this:

The embedded macro looks like this:

I've got a feeling the answer is super-simple, but I've spent hours trying to sort it out. Can anyone help? Much appreciated

Thanks
Mark

 

[theDBguy]

Hi Mark,

Welcome to AWF!

I am only guessing but maybe by having the same name for your field, textbox, and tempvar; the code may be getting confused.

 

[Mark Nash]

Hi Mark,

Welcome to AWF!

I am only guessing but maybe by having the same name for your field, textbox, and tempvar; the code may be getting confused.

Thanks DBguy, I wish I understood what you are saying! Sorry, im a total numpty. Should I delete the If statement?

 

[theDBguy]

Thanks DBguy, I wish I understood what you are saying! Sorry, im a total numpty. Should I delete the If statement?

How about this? Could you share a sample copy of your db with test data?

 

[Mark Nash]

The strangest thing. I renamed the file to put on here for you to look at, and its now working? Thank you for your offer of help, if it breaks again I'll put it up on here.

 

[theDBguy]

The strangest thing. I renamed the file to put on here for you to look at, and its now working? Thank you for your offer of help, if it breaks again I'll put it up on here.

Hi. Glad to hear you got it working. Good luck with your project.