G
Guest
I am reposting my current issue because I may have not been very clear.
I currently have a query where I need the criteria of specific fields to be
updated by a combo box linked to other tables. I have the como boxes in the
form and the query has the following code:
SELECT Budget.[Cost Center], Budget.Expense, Budget.[July 2007],
July2007Forecast.[July 2007]
FROM Budget INNER JOIN July2007Forecast ON (Budget.Expense =
July2007Forecast.Expense) AND (Budget.[Cost Center] = July2007Forecast.[Cost
Center])
WHERE (((Budget.[Cost Center])=[forms]![frm_July]![cmb_costcenter]) AND
((Budget.Expense)=[forms]![frm_July]![cmb_expense]));
Every time I click the run query option button, the query parameter request
pops up. Any help would be greatly appreciated!
I currently have a query where I need the criteria of specific fields to be
updated by a combo box linked to other tables. I have the como boxes in the
form and the query has the following code:
SELECT Budget.[Cost Center], Budget.Expense, Budget.[July 2007],
July2007Forecast.[July 2007]
FROM Budget INNER JOIN July2007Forecast ON (Budget.Expense =
July2007Forecast.Expense) AND (Budget.[Cost Center] = July2007Forecast.[Cost
Center])
WHERE (((Budget.[Cost Center])=[forms]![frm_July]![cmb_costcenter]) AND
((Budget.Expense)=[forms]![frm_July]![cmb_expense]));
Every time I click the run query option button, the query parameter request
pops up. Any help would be greatly appreciated!