OnCurrent event (cbobox) of Form: HELP !

[schredder]

Hey all
in a form i have a combobox where the user selects the category. The selection determines which listbox appears (i did it with a SELECT CASE statement and .visible=true/false)
I placed the statement in the AfterUpdate event of the combobox and i call it in the OnCurrent event of the form (Call cboCAT_AfterUpdate)
The form works actually fine but the problem is: when i close the form and reopen it and i want to browse through the already entered records, all i can see is the combobox.
The underlying table of the form however lists the records as they should be.
I just want the combo to let me select when a new record is about to be entered.
Has anybody an idea?

Thanks in advance
Chris

 

[LittleSmudge]

Sounds like the combo box is unbound.

So you need some sort of filter in the OnCurrent event to show all when combo box = Null

Eg.
If Not IsNull(ComboBoxName) Then
' The Select Statement code that you already have
End If



'ope-that-'elps.



G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[schredder]

Hey Little Smudge
Thanks lot. Think that is the right hint. Actually my form is so complex that i need to try around with ur comment. Will post here when it worked.
Chris