B
BrianH
Hi,
I have created a database with multiple tables that include monthly
budget data. In order to compare these monthly figures I have created
a form in which I can select (from combo boxes) which fields (the
months) I want from each table.
However, I cannot get the query to recognize that I want to select the
fields from the form. If I could just plop criteria from one of the
tables fields that would be fine, but I can't. I am trying to select
the fields that I pulled down from the combo boxes. For example, right
now there are three combo boxes, I can pull down January from each box
which is from the correct tables. I press my command button and go to
the query. This is where my problem arises. I cannot seem to figure
out how to manipulate the query in order to search for the fields and
tables that I selected from the form.
PLEASE HELP
thanks soooo much in advance!
~Brian
I have created a database with multiple tables that include monthly
budget data. In order to compare these monthly figures I have created
a form in which I can select (from combo boxes) which fields (the
months) I want from each table.
However, I cannot get the query to recognize that I want to select the
fields from the form. If I could just plop criteria from one of the
tables fields that would be fine, but I can't. I am trying to select
the fields that I pulled down from the combo boxes. For example, right
now there are three combo boxes, I can pull down January from each box
which is from the correct tables. I press my command button and go to
the query. This is where my problem arises. I cannot seem to figure
out how to manipulate the query in order to search for the fields and
tables that I selected from the form.
PLEASE HELP
thanks soooo much in advance!
~Brian