I have the following tables: Publisher, Titles, Genre,
I wish to have a query that will return the following information, Title of
work, Publisher Submitted to, but I wish to use the information from the
table Genre to start the query. So when I start the Query a drop down list
should appear that will allow me to select a value from the Genre table to
start the reteriving the information.
Re: Starting a query using a drop down list box ... You would have to create a new unbound form and place the dropdown control... the query would have to pull the parameter from there. ... > I have three tables, Genre, Titles and Counts, Submissions. ... > dropdown box that I can pick the correct Genre, then display for me all ... (microsoft.public.access.queries)
Re: Overflow and group by genre ... >All the information is in a table called tblmain... >I have reports made for every genre that I put into one report so they ... except maybe the part about a report...record source query and the results that you got. ... (microsoft.public.access.reports)
QBF problem with multiple combo boxes ... list of options for the Genre combo box. ... search criteria and then feed those selections from the combo boxes into ... the query that is executed when you select the ?Query? ...cbo_Media à ... (comp.databases.ms-access)
Re: update textbox based on combobox ...Genre is a list of columns that resides in a ... autofill from the query.... will zero in on the selection.... I'm very new to access but I understand nested commands in excel and have ... (microsoft.public.access.formscoding)
Re: How do i prevent duplicate choices from appearing in my combo ... Another thing you can do is to make sure that your combobox is based on a query... SELECT DISTINCT [Genre]... will only show the selections in the table and not the database.... (microsoft.public.access.gettingstarted)
