Return only specified records

[thowe]

Hello-
What I am trying to do is to have my form return a specific group of records based on the criteria that I have specified in my switchboard- I think this means that I need to utilize a filter? Here is what my form does now:

form called "choices" asks users to choose from a combo box a list of titles, then when the user clicks on the combo box another form "videolist" opens up and goes straight to the video choice. But there are a number of videos that have the same name, so I want the "videolist" to return ONLY those that equal the choice from the combo box- not all titles but jump to the title that I want.

Please, if you can help me with this, I'm sure it's just a simple step I am missing. I have been working with the Macros feature, so if anyone knows how to do this with macros- I must just be missing a simple step. thank you
thowe@san.rr.com

 

[AlexMidd]

Well, does the video list just have names in it or is there, are there should be, an index of some sort, i.e. a primary key. The first rule of databases is that there should be aprimary key that uniquely identifies every record. If some of the video names are identical then the video name cannot perform this function.

If there is a primary key, you need to set the combo box to a query that has this key and the video name as its Row Source, set the Column Count to 2 and the Bound Column to the primary key. Then, when someone selects a video (or videos) the value(s) returned will be the primary keys and not the names, so it will always know which ones are being referred to.

Just a thought, if some of the video names are the same, how does the user know which one s/he is selecting?

Have fun! )

Alex Middleton