Opening Form from a Different Form to Specific Data

[audreyestelle]

I have a form in access entitled FrmContact Certain Contacts have a separate Point of Contact. Therefore, I have created a form entitled FrmPointofContact. I would like to be able to click a button on FrmContact and have FrmPointofContact Open. I would like it to open to Point of Contact that is associated with that person, or to a blank form so that people can input a point of contact if there is not one previously associated with that contact. \

Can someone tell me how to do this either through VBA or a macro?

Thank you!

[pbaldy]

This should get you started:

http://www.baldyweb.com/wherecondition.htm

[audreyestelle]

I have tried this but it keeps coming up with a compile error.

[pbaldy]

Hard to figure out why without seeing your code.