Pop up Form to set parameter of query to generate a report

[Carl]

I have a pop up form that opens when I run a report via a
macro. The query searchs for an item (drug) that has 2 different
mnemonics. (fields are mnemonic2 and mnemonic3 from table PDM) I
cannot append the table fields into a new column because the table is
on a server that does not allow changes.
The problem is that I cannot figure out a way to attach
[Forms]![frm_mnemonic]![lstbox] ---the combobox I am using on the form
----to mnemonic2 and mnemonic3 so it it will search both since they
are both text values. I can attach it to one or the other field and it
works fine, but when I attach it to both the report fails.
Or is there a way to make a field that is appended in the
query so I can attach the form to the one field. I have only been able
to find ways to create such a field in a table. I have been able to
merge the fields but that just combines the mnemonics for each drug.

thank you
carl

 

[pietlinden]

I have a pop up form that opens when I run a report via a
macro. The query searchs for an item (drug) that has 2 different
mnemonics. (fields are mnemonic2 and mnemonic3 from table PDM) I
cannot append the table fields into a new column because the table is
on a server that does not allow changes.
The problem is that I cannot figure out a way to attach
[Forms]![frm_mnemonic]![lstbox] ---the combobox I am using on the form
----to mnemonic2 and mnemonic3 so it it will search both since they
are both text values. I can attach it to one or the other field and it
works fine, but when I attach it to both the report fails.
Or is there a way to make a field that is appended in the
query so I can attach the form to the one field. I have only been able
to find ways to create such a field in a table. I have been able to
merge the fields but that just combines the mnemonics for each drug.

thank you
carl

filter report with a listbox... there's an article that shows how to
do that at www.mvps.org/access (Access Web)... Ithink it's in the
reports section.

 

[Carl]

I have a pop up form that opens when I run a report via a
macro. The query searchs for an item (drug) that has 2 different
mnemonics. (fields are mnemonic2 and mnemonic3 from table PDM) I
cannot append the table fields into a new column because the table is
on a server that does not allow changes.
The problem is that I cannot figure out a way to attach
[Forms]![frm_mnemonic]![lstbox] ---the combobox I am using on the form
----to mnemonic2 and mnemonic3 so it it will search both since they
are both text values. I can attach it to one or the other field and it
works fine, but when I attach it to both the report fails.
Or is there a way to make a field that is appended in the
query so I can attach the form to the one field. I have only been able
to find ways to create such a field in a table. I have been able to
merge the fields but that just combines the mnemonics for each drug.

thank you
carl

filter report with a listbox... there's an article that shows how to
do that at www.mvps.org/access (Access Web)... Ithink it's in the
reports section.

If it is there, it is above my head....thanks anyway

carl