Search results

Hi, I have a db with four combo boxes, three individual cbo's using one to filter their contents. My problem is that when a complete record is made and I move to input the second module data the first row's selection is present. I feel sure this should be avoided as mistakes could be made. Can...

Hi, I found this 15 pages back the way. Good Stuff. Private Sub cbo1_AfterUpdate() Dim varID1 As Variant Dim varID2 As Variant Me.cbo2.Requery varID1 = Me.cbo2.ItemData(0) Me.cbo2 = varID1 Call cbo2_AfterUpdate varID2 = Me.cbo3.ItemData(0)...

We can try again

Hi Here is a zipped version with the corresponding bits in it. Cheers iain

Hi, Thanks for answering. i have put in the requery bit and the second cbo responds, I have tried to put in statements to to requery the third and fourth cbo's but they do not work. Cheers again i:confused:ain

hi, I have a db which uses the data taken from cboInstructors which is used in a query and a produces a list in cboExpertise. This procedure is repeated from cboInstructors for cboAssessors and then cboIVName. This subform then shows all the modules each student have taken, who taught it, who...

hi Yep I got it sorted Thanks iain:cool:

Combo box Problems Cheers big man I shall have a wee look. Ta Iain

We Continue with combo box Query Problems Hi, Thanks for the help. Seems to have helped a lot, I can select the Area of Expertise but in the second combo box I get the following error message: Enter Parameter Value Forms!Students! Module_Subform!cbo Expertise I submitted in your code the...

Hi all. I am a relative beginner using Access and I am still using 2003 I am trying to develop a database to store student details, module details and area of expertise of lecturers The tables are Students,ModuleName, Instructors and Expertise. I have a students form with a module subform. In...

Hi all. I am a relative beginner using Access and I am still using 2003 I am trying to develop a database to store student details, module details and area of expertise of lecturers The tables are Students,ModuleName, Instructors and Expertise. I have a students form with a module subform. In...