Hopefully this will Explain my Predicament
Question:
I have three objects a Main_Table , ClientDataForm and a MapForm all three share a common ClientID number
From that Main_Table I have created a ClientDataForm form which I enter all Data
From ClientDataForm I wish to create a button on it which runs a Macro that Saves ClientDataForm Record and then populates another form named MapForm with whatever record is currently open in Form One whether a newly created one or previous record. Does anyone know How would I write this code for that button? Also why I would write it that way?
I have been racking my brain lol Thanks Everyone for all your support