Using data on my form to show other data (1 Viewer)

[peterb]

Could anyone tell me if it is possible to use data from a combination of a combo box and two text boxes to show data relating to that data from a table?

I have a table named COURSE which holds course information (Title, Location, Date etc.) and would like to search this table using the data entered on a form.

Help me access-programmers, you're my only hope ! !

 

[charityg]

Why not use three combo boxes? That way, your locations and dates will only show the correct list. For example you choose a course in the course combo box and then your location combo only list the pertinent locations for that course, and then your date only lists the pertinent dates for that location. Put these combo boxes on a main form and then use a subform and use the combo boxes as criteria for the subform.

 

[peterb]

That sounds ideal, but could you help me further by telling me how to link the data in the combo boxes to what is shown on the subform ?

Many thanks once again.

 

[Rich]

"Solutions" database supplied with Access has examples of how to do this.