combo box that prints

[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?

 

[Guest]

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 & "'"

 

[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?