J
jeff
I have a combo box with 3 fields in it. I need to create
a querry that looks at the value inthe 3rd field. How
would I do this? I know how to create the field in the
querry to look at the combo box, but I do not know how to
make it look at the 3rd field.
Example,
I ahve a combo box with room description, room number,
and fieldname.
The room description and room number are easy
recognizable ways for the user to select the room. I
need to run the querry off the fieldname to compare to
the fields in the main table.
The reason for this is that I have about 35 rooms that
the user can select. I need to generate a report and form
that will pull in all events that have been in the room
specified by the combo box.
a querry that looks at the value inthe 3rd field. How
would I do this? I know how to create the field in the
querry to look at the combo box, but I do not know how to
make it look at the 3rd field.
Example,
I ahve a combo box with room description, room number,
and fieldname.
The room description and room number are easy
recognizable ways for the user to select the room. I
need to run the querry off the fieldname to compare to
the fields in the main table.
The reason for this is that I have about 35 rooms that
the user can select. I need to generate a report and form
that will pull in all events that have been in the room
specified by the combo box.