Query for Report Generation via Form?

[jcleary47]

Hello all,

I've made some good progress in my quests to learn access by browsing these forums, but unfortunately I've hit a wall and I'm not sure what to search for at this point that pertains to my problem.

What I have is an excel sheet that has a list of application names and their associated dependencies. What I'm ultimately trying to do is import these into access so that I can look up an application and see what the dependencies for that application are.

I've gotten myself to a point where I thought this would be simple, however this seems to not be the case.

I think my problem might be the fact that when I exported this data into excel, if an application has more than one dependency it lists the application name again for each dependency.

The report I generate from this query looks exactly how I want it, except I can't get it to show only one application based on my selection in a combo box.

I tried to use command button to execute an opening of the report and linking the selection into the combo box but I must say I honestly am stuck at this juncture and have no idea what method I should be using to obtain this goal.



My thinking is I am relatively screwed because each application doesn't have it's own key since they are listed multiple times.

Any suggestions would be greatly appreciated

[June7]

Options for generating a filtered report:

1. dynamic parameterized query, review http://www.datapigtechnologies.com/f...tomfilter.html
That example works only for text type fields. Number and date/time types have to be handled differently because wildcard does not work with them.

2. I don't use dynamic parameterized queries. Review http://allenbrowne.com/ser-62code.html

[jcleary47]

Thank you, that helped me get the combo box sorted out to get the application names listed. I believe the aspect of this that I really can't seem to figure out is getting the dependency listbox to populate with the dependency names associated with the app I am selecting in the combo box:

[June7]

That sounds like cascading combo/list boxes. Review http://www.datapigtechnologies.com/f...combobox2.html

[jcleary47]

That sounds like cascading combo/list boxes. Review http://www.datapigtechnologies.com/f...combobox2.html

Yes this makes sense. So it shouldn't be an issue that some of my "Application Names" are the same right? I'm assuming Access will know from query logic that repeat information in that column should be tied together?

On my original they all have individual keys, but on my query the application names have their own key and the dependencies have their own key so I guess this is how it differentiates them?

[June7]

I'm not sure the ID field is even involved - would need to know more about database structure. The picture looks good.