C
Carl
I have a popup form with a combobox to select a field from a
query to generate a report. The combobox however needs to pull from
mnemonic2 and mnemonic3 fields in table PDM. I cannot make an appended
filed in the table as it is on a server and is unchangable.
1. Can I make an appended field in the query for the 2 fields to which
I can attach the form to open when the report starts? I have tried to
combine the fields and that just merges the 2 different mnemonics for
the item. I just want to search both columns for the mnemonic enetered
by the user.
2. Can the combo box search both fields without keeping the popup form
from working? I have not been able to attach the form criteria to 2
filelds and have it work.
thanks in advance
carl
query to generate a report. The combobox however needs to pull from
mnemonic2 and mnemonic3 fields in table PDM. I cannot make an appended
filed in the table as it is on a server and is unchangable.
1. Can I make an appended field in the query for the 2 fields to which
I can attach the form to open when the report starts? I have tried to
combine the fields and that just merges the 2 different mnemonics for
the item. I just want to search both columns for the mnemonic enetered
by the user.
2. Can the combo box search both fields without keeping the popup form
from working? I have not been able to attach the form criteria to 2
filelds and have it work.
thanks in advance
carl