testing Combo Box Values to Table

[LBitner99]

Ok here's the situation,

I have 2 combo boxes and a text box. Combo1 sets the list of values for Combo2. Combo2 either allows you to 1.) select a value from the list. or 2.) enter a value yourself. textbox is supposed to update from a different source if you enter something in yourself rather than choosing a value from the list. I have the Code working that sets the value if you select something. but i cant for the life of me figure out how to get it to default to a different set of values if you type something in. im using the lost focus event as the trigger for the code. HELP!

 

[LBitner99]

Nevermind all,

Apparently the code i tried 6 hours ago, seems to be mysteriously working now:
If [Name of task Performed].Value = [Name of task Performed].Column(0) Then
Forms!frmInput!AQL.Value = [Name of task Performed].Column(1)
Else
Forms!frmInput!AQL.Value = [Assessment Name].Column(1)
End If

So simple.... so unrefined... so about to drive me into total insanity ;o)