Appended field in query

[Carl]

1. Can I make and appended field form 2 fields in a query (NOT
A TABLE). The fields are mnemonic2 and mnemonic3 in qry_mnemonic based
on an unchangable table PDM?
or
2. Can I attach [Forms]![mnemonics]![combobox1] to each field
in the query so I can do a partial lookup of both fields in this
unbound combobox? I have tried this with no luck. I can only attach to
one field and have it work. The form is a popup form attached to a
report by a macro.

I am a novice so please be specific.

Carl

 

[tina]

if you're having trouble getting the query to work when you use the same
form control as criteria for more than one query field, then just put
another combobox control on the form, and use that as criteria for the
second field in the query.

if you want the user to have to choose from only one combobox on the form,
not two, then make the second combobox invisible, and set it's ControlSource
to
=[combobox1]

hth