button that opens form

[rwest]

Hello
I created a floods sub form in my main publications form. In this sub form I created a button that opens another from called info connected with a specific flood id. When I click on the button in the subform for a flood id #1 the right data form opens, when I click the button for a different flood id it only opens the data form for flood id #1. If this makes sense to anyone and they can help me it would be greatly appreciated.
Also I didn't write code for this, it has an embedded macro, it opens the floods form Where "[floodid]=" & [floodid]. I don't know if I need to write code for this but if so could someone give me a hint to what it might look like.
Thanks

[pbaldy]

Is this what you're looking for?

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

[rwest]

Yep I figured it out, I wasn't calling the right table.

[pbaldy]

Glad you got it sorted out.