OpenForm Macro

[davey3389]

On the Openform option on Macro's what do I need to type in to get my form to open where the "ID" field from "Employee Phone Search" form matche the "ID" field from "Employee Details" form

Cheers

 

[pbaldy]

If you want to use VBA instead of a macro:

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

If you want to stay with the macro, hit F1 while in that option and you should get context sensitive help on the syntax.

 

[davey3389]

F1 didn't seem to help me much

But I tried

"[ID] =" & [Forms]![Employee Details]![ID]

and that did not seem to work

 

[pbaldy]

In a macro? The syntax is different there, which is why I suggested looking in help.

 

[pbaldy]

My help shows this as the format for a macro:

[fieldname] = Forms![formname]![controlname on other form]

 

[davey3389]

When i typed that in, it opened the form but showed no results

 

[pbaldy]

Can you post the db here so we can fix it?