Novice - Use the values from a table in a drop down list to filter a report

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I have a small database with a master record (with its own table). The
master record includes a countryname field which is linked to a
separate countries table listing all the available countries. I want
the user to be able to click on a command button, get a prompt to
select a country from a drop down list, and then the choice will be
used to fiter a report. Is there any way to do this?
 
Kevin said:
I have a small database with a master record (with its own table). The
master record includes a countryname field which is linked to a
separate countries table listing all the available countries. I want
the user to be able to click on a command button, get a prompt to
select a country from a drop down list, and then the choice will be
used to fiter a report. Is there any way to do this?
Click to expand...
 
Sorry my message didn't post.

I don't have time to rewrite now.

Use an unbound combo box with Country table as row source...then use a cmd button that prints the report....but sends the country selected in the combo box to the report instead of the entire report using a small adjustment to the code.

More later
 
Back
Top