Originally, my goal was only to select all records in the "forecast_i nfo" table where the table field "f_model" was equal to the content of a form field "v_model". I was able to achieve this with the following query.
Code:
PARAMETERS [Forms]![vehicle_info_form]![v_model] Text ( 255 ); SELECT forecast_info.f_model, forecast_info.f_year, forecast_info.f_production, forecast_info.f_sales