Recent content by sheepchild

Think i have managed it! Private Sub Form_Current() If Me![EventTitleCombo].ListIndex < 0 Then Me.MinNoFaculty = [MinNoFaculty] Else Me.MinNoFaculty = DLookup("MinFaculty", "tbl_CourseNames", "ID=" & [EventTitleCombo]) Me.MaxNoDelegates =...

Oooooh thank you. if i wanted extra defaults such as maxCandidates (same look up how would this work as it all set via the combo box as apose each text box its being posted too? tried a few things but keep getting errors thank you again massive step forward for me

I have a random issue which i cant work out i have a look up =DLookUp("MinFaculty","tbl_CourseNames","ID=" & [EventTitleCombo]) which works in a text box under the control source and show the correct value i want but i want this in the default value with the control source [MinNoFaculty] but...