Open form based on table values

[rmurry]

I'm sure I can't be the first to need this, but I have yet to find it.

I have a table with the fields Thermometer_ID (primary key) and CalibrationType (combo box list with the options of InHouse or SendOut)

I want the user to click on a button and have an input box to input the thermometer_id. Then if the CalibrationType is InHouse open form Verification and if it's SendOut open form Thermometers.

I don't care if it's done by VBA or an access macro.

Thanks in advanced.

 

[llkhoutx]

The form recordsourtce should be filtered by "Forms!YourFormName!CalibrationType" and insert a "Forms!YourFormName.Requery" in the Forms!YourFormName!CalibrationType_AfterUpdate" event.

The form has to be requeried each time its filter changes.

 

[mohsinj677]

I want the user to click on a button and have an input box to input the thermometer_id. Then if the CalibrationType is InHouse open form Verification and if it's SendOut open form Thermometers.

____________
Mohsin