Union issue

[Michelle]

I have a Union Querry (code below) what it does is combine two tables one
with information already in it and the other empy one where you enter more
data.
What I want is to be able to use the Query when i creat a form however I
have a problem. I want to enter the IN_INMNUM and it then pull the
information from inmateinfo I don't want it to return all the information in
the inmateinfo table just the information for the IN_INMNUM that I enter.

SELECT
Inmtinfo.IN_INMNUM,
inmtinfo.IN_NAME,
inmtinfo.IN_RACE,
inmtinfo.IN_BLDING,
inmtinfo.IN_SECTION,
inmtinfo.IN_CELLDRM,
inmtinfo.IN_BEDNUM,
tblCellChange.M_BLDING,
tblCellChange.M_SECTION,
tblCellChange.M_CELLDRM,
tblCellChange.M_BEDNUM,
tblCellChange.M_REG,
tblCellChange.M_EMG,
tblCellChange.M_REASON,
tblCellChange.M_DATE
FROM inmtinfo LEFT JOIN tblCellChange ON
inmtinfo.IN_INMNUM=tblCellChange.IN_INMNUM;

 

[Jeff L]

If I am reading this correctly, you should be able to accomplish this
by creating a combo box on your form. When the wizard starts, there
should be an option that says "Find a record based on the value
selected", or something to that effect. Make sure your form has a
record source and that your combo box is not bound to a field in your
data source. Hope that helps.