About filters

[registan]

Hi,



When i click on a record in a form, i want macro to open another form and go to exact record which i clicked on. How can i do that? Please help.

P.S. im using Microsoft Access 2007

[RuralGuy]

This link should help: http://www.baldyweb.com/wherecondition.htm

[registan]

Thank you RuralGuy,

I don't know what to write in "ControlName". Let's say i have "Personnel" form and "Summary" form, both of them have column "Personnel_ID", i want to have info in the form "Summary" about the exact Personnel_ID which i pressed on in the form "Personnel". Sorry for my english...

[RuralGuy]

I would start by using Personnel_ID in place of the Controlname and see what happens.

[registan]

No, didn't work, actually i don't really know how to use VBA code, i usually use Microsoft Access' own commands. Anyways, thank you very much.

[RuralGuy]

Post the code you are using.

[registan]

I will send you my mdb file.

[registan]

By the way, how can i get the code?

[RuralGuy]

Can you post your db?

[registan]

This is my db, if you click on "Sicil" in "PerList" form, it will open "PerListSum" form and goes to first record. I want to go to exact record which i clicked on.

[RuralGuy]

Aee if this works for you.

[registan]

Yeah it works, thank you Rural.

[RuralGuy]

Great! Do you see what I did?