R
radiaz via AccessMonster.com
I have a form with a command button. When the command button is clicked, a
parameter box pops up asking for a whole or partial number. I created a
query using to tables. In one table I selected a field called Document_ID
along with other fields to be on the query and in the other table I selected
Referenced_ID. The
Document_ID field contains numbers. One Document ID has many other numbers
(Reference_ID)
In the query under Document_ID column, I did this "[Forms]![frmReports]!
[Combo5]". Then I created a report using the query. When I go to the form
and click on the command button, it prompts me for a number, I enter a whole
number or just a partial number, then it works good. It opens up the report
But it 's only looking in one column. I'd like to be able to search in the
Document ID column and Reference_ID column at the same time. Is that
possible in Access?
I'd appreciate any help you can give me.
Rita
parameter box pops up asking for a whole or partial number. I created a
query using to tables. In one table I selected a field called Document_ID
along with other fields to be on the query and in the other table I selected
Referenced_ID. The
Document_ID field contains numbers. One Document ID has many other numbers
(Reference_ID)
In the query under Document_ID column, I did this "[Forms]![frmReports]!
[Combo5]". Then I created a report using the query. When I go to the form
and click on the command button, it prompts me for a number, I enter a whole
number or just a partial number, then it works good. It opens up the report
But it 's only looking in one column. I'd like to be able to search in the
Document ID column and Reference_ID column at the same time. Is that
possible in Access?
I'd appreciate any help you can give me.
Rita