combo box that prints

  • Thread starter doug d via AccessMonster.com
  • Start date
D

doug d via AccessMonster.com

I want to make a combo box that has the names of about 15 companies.
I then want a button under it that when a company is selected you can hit the
button and it will print a file that assign to that company. Any ideas?
 
D

Dennis

By print a file, I assume you mean a report ?
In the code for the button click put something like this

DoCmd.OpenReport "ReportName", acViewPreview, , "[FieldName] = '" &
ComboBoxName & "'"
 
D

doug d via AccessMonster.com

I have an access database with links to different company profiles in Word.
I want a combo box that lets you pick the company name and then hit a button
under it that will print the company profile and some other Word files that
go with the company profile, but are not part of the same file.
Thanks
By print a file, I assume you mean a report ?
In the code for the button click put something like this

DoCmd.OpenReport "ReportName", acViewPreview, , "[FieldName] = '" &
ComboBoxName & "'"
I want to make a combo box that has the names of about 15 companies.
I then want a button under it that when a company is selected you can hit the
button and it will print a file that assign to that company. Any ideas?
Click to expand...
Click to expand...
 
Top