change field data displayed by other field on form

P

Phil

thank you to anybody who can come up with a solution to my pain

i have created a form [frmSchedule] to collect details about my course
schedule, i have a field [EventsID] that selects data from another table
[Events] (this works) i then have another field date which i would like to
select data from table [tblEventslocation] dependent of what is entered in
the field [Events] i do not know how to do this:-

i have set up a select query

SELECT DISTINCTROW [tblEventsLocation].[ID], [tblEventsLocation].[Date],
[tblEventsLocation].[Event ID], [tblEventsLocation].[Day],
[tblEventsLocation].[Venue] FROM tblEventsLocation;

this shows all the dates available, i just want to be able to only show the
dates for the event that has been selected

I hope someone can help

thanks for your help in advance

Phil
 
Top