Recent content by cityofdowney

Thank you very much. It is working. Thank you for taking the time and helping me out.

Sorry I forgot to give details Use the signon form -user (jbenavid) password (test) Button - subscriptions find existing record - jones Subform other residents - (delete button) should move data to history This where the error is happening. Query: other resident history append Marco...

Database attached I hope it works since I had to delete out peoples address. Thanks for helping me.

Still not working Since I did not originally create the access forms, I deleted the subform out and readded the subform. Still getting the sam error. What else do I need to look at? Thanks

Thanks but it still does not work Actual line typed: [forms]![subscriptions form]![other residents subform]![Form]![ot-othres-id] Pop up box ask for the "enter parameter value". Does it matter if it is a button on the subform and runs through a macro?

How do you pass a primary key to an append query from a subform? Example: Main form – Table Subscriber (subscriber-id – primary key) Linked (subscriber-id (main form) = ot-subscriber-id (subform)) One to many Sub form - Other residents (ot-othres-id – primary key) From sub form...