Creating Form to Target Current Record Open in Another Form

[wes9659]

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

[June7]

You just want to open MapForm filtered to the same record on ClientDataForm? Why? If you just viewed record on ClientDataForm why do you need to then view it on MapForm?

What field has the unique ID of records on ClientDataForm? Use that ID to filter MapForm.

DoCmd.OpenForm "MapForm", , , "ID=" & Me.ID

[wes9659]

Thank You For your Help.

I have attached a version of the access database located in dropbox. Basically I tried to word question using generic table names. So when you look at the project the main table is actually called the Primary_Data_Table, Form One would correspond to my Basic Demographics Form and MapForm would correspond to FrmClientHomeLocator. The button is located on the Basic Demographics form named Client Home Locator. It is set to Macro named MarcoMap . (Funny thing also if you click on background anywhere on Basic Demographics Form it launches MapMacro.


Bill

https://www.dropbox.com/s/b6gvyew3bn...essProject.zip

[June7]

You are using Navigation Control/Form. I don't use this object/control. Don't like it, I think it is more difficult to work with. Review https://www.accessforums.net/forms/t...orm-32053.html

It might be the reason that clicking anywhere on background executes opening the form but why the map form button and not one of the other two is beyond me.

I also do not use macros, only VBA.

Sorry, can't help.