C
Carl Mankat
I am running W2K and Access 2K. I am trying to pass a value from a Combo
Box to view a report using a command button. I have not done it for some
time and I am having problems doing it.
I created a form (Form1) with a Combo Box, creating Combo5. I then
created a command button to open a report, Rpt_Inv. Then I saved the
form and edited the query for calling the report. The query has fields
from a table, Tbl_Phones. For the field, LName I used the Build tool to
place the following in the criteria: Like[Forms]![Form1]![Combo5]&"*".
Results:
When I open Form1 and select a last name and click on the Command Button
to open the report I get a report with one record in it but there is no
data. If I open Form1 and then click on the command button, I get all of
the records in the report. This tells me that the &"*" is working and
I'm on the right field.
What is it that I am missing? I use Access occasionally and seem to have
forgotten something.
TIA,
Carl
Box to view a report using a command button. I have not done it for some
time and I am having problems doing it.
I created a form (Form1) with a Combo Box, creating Combo5. I then
created a command button to open a report, Rpt_Inv. Then I saved the
form and edited the query for calling the report. The query has fields
from a table, Tbl_Phones. For the field, LName I used the Build tool to
place the following in the criteria: Like[Forms]![Form1]![Combo5]&"*".
Results:
When I open Form1 and select a last name and click on the Command Button
to open the report I get a report with one record in it but there is no
data. If I open Form1 and then click on the command button, I get all of
the records in the report. This tells me that the &"*" is working and
I'm on the right field.
What is it that I am missing? I use Access occasionally and seem to have
forgotten something.
TIA,
Carl