C
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
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