Combo and textbox 1

[kriza]

Hi all,
I have a problem another combo related problem thats driving me crazy,

heres my scenerio:
Combo A - Class
Combo B - Class Section
textbox - Time

When a user selects a class, combo B shows the sections available for that class and then once the user selects the section, the time for that section shows up on the textbox. My combos work but when they select a section, it
shows a time for a different class with the same section e.g I have Physics and chemistry, both with 4 sections, if the user selects Physics, it shows section 1, 2 etc but when they pick section 1, it shows the time for
Chemistry, Section 1..

My "after update" code for combo B is:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Course section]= '" & Me![ComboB] & "'"
Me.Bookmark = rs.Bookmark

End Sub

Any advice on how to get this working will be very appreciated.. Thank you.

 

[jebry]

Hi!

Try this:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Course section]= '" & Me![ComboB] & "' And Class = '" & Me!ComboA & "'"
Me.Bookmark = rs.Bookmark
Set rs = Nothing

End Sub

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[kriza]

Jeff, you da man, it worked perfectly.. quite simple..