Inventory Problem Beginner Database

[joe.ise]

I added the End If, ran the debug / compile, no errors. From what I learned previously if I have a module I have to "call it up" in the form with code written into the form like we did before. I tried to replicate that (see screen shot) and got an error (see screen shot).
I changed the Me.Text6 to Me.Text7 and still got the same error.
Thanks

[RuralGuy]

Do a Find on the Project for OnHandTwo( and see if there is more than one somewhere.

[joe.ise]

Left my laptop at home. Gettin old. Going to try to get it during lunch, if not, get back to you soon. Thanks

[joe.ise]

I could not figure out how to do a find on the project. I did notice that the db file I saved and sent back to you last did not have my code in the CurrentInventory form. I have corrected that. Can you give me some help on understanding how to do a "find on the project".
Thanks

[RuralGuy]

While viewing code, go to Edit>Find and select Current Project.

[joe.ise]

OK
I did that for Module2. See attached. I found 3 instances in my code that read "OnHandTwo". I did not find any instances that read "OnHand".
I did that for Module1. I found 2 instances in my code that read "OnHand". I did not find any instances that read "OnHandTwo".
I think that is what you wanted me to do. Is that correct ?
Thanks

[RuralGuy]

I think that is what you wanted me to do. Is that correct ?

You've got it now. Good luck.

[joe.ise]

Any idea what might be throwing the attached error ? Thanks

[RuralGuy]

You have defined TWO OnCurrent events for that form. Delete one.