How to filter a form based on another form.

[Traven]

I have a form which uses a parameter based query to present an individual senior doctor with a list of names for of individual juniors to provide an assessment report on. When the first form opens the user enters their RespondentID. Once senior has decided which names to comment on I have another form which has the questions to be answered which is opened by clicking a button on the first form.
How can I pass a parameter from the first form to the second so that only the records relevant to that senior doctor are displayed? The underlying table has 60 senior doctors and 20 junior doctors. The senior doctor is identified by the field RespondentID in the first form. I've tried putting a WhereClause in the FormOpen command but I still get a dialogue box asking for the parameter RespondentID when the second form is opened.
I'm sure I'm missing something really simple here but as a beginner I can't work it out.

 

[boblarson]

See if this helps:
http://www.baldyweb.com/wherecondition.htm

 

[Traven]

Thanks boblarson - it worked.
I'd been putting everything inside quotation marks - it's not exactly intuitive! Also I'd forgotten that the field was a number field rather than a text field.
Anyway thanks very much once again.