Jason,
In your Search form, get the correct Office record. Then when you call the OFFICES form pass a parameter with the Primary Key value

DO FORM OFFICES with MyPKValue

In the INIT() of the OFFICES form, add a parameter line, with the PK value as the parameter. Finally, open your Offices table, find the right record and refresh the form. Note: The parameter passed into the Init() method is local to the Init() code. If you want to use it in other methods be sure to save it to a form property.

HTH
Barbara


>Hello everyone:
>
>Mission:
>
>To have a command button on my OFFICE SEARCH form that fires my OFFICES form with the specific office the user selected in the search form.
>
>
>I have 6 combo boxes on my search form:
>
>1.country
>2.state
>3.county
>4.locality
>5.district
>6.office title
>
>** If the user selects
>
>USA
>Florida (state)
>Dade (county)
>Miami (locality)
>15 (district)
>Mayor (office title)
>
>
>I want to have my OFFICES form pop up with the record that is holding the last three combo boxes (locality, district, mayor), for the user to view.
>
>Can anyone assist me with the best way tackle this proceedure and the code to make it happen?
>
>Thank you in advance for any help
>
>Jason