Form not feeding macro enabled form with where clause

[gumbi17]

I am fairly new to the Access world and i have run into a problem with my macro enabled button. The forms name is called Well Master and has an autonumber every time a new record is created. All this information is fed to a Well-Master Table, but here is where I am getting into problems. I have a macro enabled button that launches a note feature so someone can write a note on the well, but the table that holds the note is in a table called Memos. When I press the button I want it to take the well autonumber and attach itself to the memo for population into the other table, but it is not happening. It will allow you to fill out everything on the form but without having the well number you can not tell what the note is attached to. So it goes to the table but is not attached to anything. It seems that when I change my where clause I get a lot of different results, so that is where I feel I am failing. The form is called Memo Form Well but the information for the note is within a subform called Memo Form Lease Well. Can you see anything wrong with my macro and help me get this working?