It worked!

The syntax that worked is [target field name]=[Forms]![originating form]![originating field name]. Where the value in the 'Originating Field' and the 'Target Field' are to be equal.

Thank you all. Reading your input in the previous posts in this thread helped get my thinking going in the right direction.

The full method I used is this:

Go to Macros;
Create a new macro;...

Correction to my previous post. The 'Where Condition' statement is [ID]=[Forms]![referring form name]![ID].

[ID] is the key field. I believe I am seeing something; the statement after the = is the key field (the field linking the two forms) in the Form you are using for the source of the data and the [ID] before the = referrs to the cooresponding field in the target Form.

Is this correct?

I'm having a similar problem. I am programing a Contact Management database for a friend and one of the problems I am encountering is the one described above.

I have successfully accomplished this operation in another Prospecting database I have written. In that database I use a macro to OpenForm with the Condition set to [ID]=[Forms]![ID].

This switches between two different prospecting forms generating from different...