Select a record from a combo box to preview report

Clownfish1980m

Clownfish8182m
Local time
Yesterday, 19:59
Joined
Sep 18, 2009
Messages
40


I have created a database that is going to be used to look up medications to determine if donors are suitable for donating. I have a form called “Medication Search”. On this form I have a combo box that allows the user to select the medication either by a drop down or by typing the first letters and then selecting it. The problem I am having is it doesn’t show the correct information. To resolve this, I would like to have it where the user selects the medication and then click on a command button to show the report for that drug only. I created a command button to view report but it shows all medications and not the one selected. I am also open to other suggestions for searching. Ken
 
Well, first off, maybe we should work on getting your form to show the correct information. How did you build this combo box? Make sure that your look up for it is not at the table level, and that you built the lookup using the combo box wizard.
 
I may have figured something out. I went in and read on one of the posts that you can create a combo box that will look up items from your main table. The instructions show how to create a command button to open up to report preview. Having this knowledge, I then explored more and realized I could have it open up to a form with the exact information I need. I then created a form that allows no changes, data entry or tab stops. This prevents altering the data. I created another combo box that take the user back to the selection list. Ken
 

Users who are viewing this thread

Back
Top Bottom