Combo Selections on a booking form

[fapa via AccessMonster.com]

im having soo much trouble creating cascading/dependent/auto populate combo
boxes can someone please help me!!

Im creating a booking form that allows users to book a Class depending on
their selections in the combo boxes on the same form.

All Class details are stored in ClassTimetable which has the ClassID,
ClassName, ClassDate, ClassTime and ClassRoom.

The booking form needs to have 3 cascading boxes that will allow the user to
book a Class (NOT edit the class timetable!) -
combo1 should display the name of the class, combo2 should display ONLY the
dates that class is running and combo3 should only display the times that the
selected class is on depending the past combo box selections.

Combo1 needs a DISTINCT as the ClassTimetable has many of the same Class's e.
g. Biology, but on different dates/times.

I know this question is asked alot but i've tried every suggestion and
nothing works!

I tried this :
sSQL = "SELECT Class_id, ClassName, ClassDate, ClassTime " _
& " FROM ClassSchedule WHERE ClassName = '" & Me.Combo1 _
& "' ORDER BY ClassName"

But it comes up with an error saying Criteria Expression Mismatch (Becasue
first entry of combo box is text and the second combo outcome is numeric (i
dont know how to fix this!)

I've edited row source/after_update/on click/ typed in requrey coding but
NOTHING works

I can only get the first combo box to display the class names (with Distinct)
but the rest just doesnt seem to work. can someone please please help - ill
be forever grateful!

 

[Wayne-in-Manchester]

http://support.microsoft.com/kb/289670/en-us will point you in the right
direction BUT BUT BUT (3 BUT's) you MUST include a Refresh code after each
update (when you move to the next drop down) or you WILL NOT save the data
into a table.
When you contact MS about this you will get a reply that states - we are
aware of this problem. Enough said.

Hope this helps

 

[fapa via AccessMonster.com]

thank you for ur suggestion! - i've already tried out the site and it works
when i use it with the Northwind system but when i put the coding on to my
form, it says that the data doesnt match - critera mismatch - because my
system has a text input on the first combo and a numeric input on the second -
it's driving me mad!

thanks for the refresh hint - do you how it might be writen?

http://support.microsoft.com/kb/289670/en-us will point you in the right
direction BUT BUT BUT (3 BUT's) you MUST include a Refresh code after each
update (when you move to the next drop down) or you WILL NOT save the data
into a table.
When you contact MS about this you will get a reply that states - we are
aware of this problem. Enough said.

Hope this helps

im having soo much trouble creating cascading/dependent/auto populate combo
boxes can someone please help me!!

[quoted text clipped - 32 lines]

but the rest just doesnt seem to work. can someone please please help - ill
be forever grateful!