Still Trying to Sort My Verse Database - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Still Trying to Sort My Verse Database

Tony Hudson

10 days ago

I have successfully created a query which uses 2 criteria to select a number of verses which matches the the criteria chosen. From this list I want to select one of the verses which I want to use to print the verse. I am thinking to use a report to print out the verse. I have tried to use the list box method based on the query, but i cant work out how to run the query to populate the listbox and then not sure how I select a verse from the list box to put into the report?

Donald Blackwell @Reply

10 days ago

Please be more specific. See Rule #2.

It should be easy to do, but it is difficult to help you with specifics since we have no idea what data/fields we are working with.

If using a list box, the rowsource would essentially be the results of the query with at least one field that represents a verse ID or something similarly unique. Then in the After Update event of the list box, you would open a report based on that ID. Here are two Tech Help videos that may be relevant:

Open Report
Open Report 2 Ways

	Richard Rost @Reply 8 days ago
I've got to back up what Donald said. I have no idea what you're asking from this question. Can you give us more specifics, maybe some screenshots? Help us to help you.

Next Unseen

New Feature: Comment Live View