M
Maarkr
Started a new db cataloging events...each Event is categorized by Title, and
some titles may be further categorized as items. The events have only one
Title descriptor, which you select with a combo box which looks up about
twenty different title categories for you to select from. However, there are
2 categories of Titles that I want to further categorize as items and have
another combo box lookup a list of items...for instance if you select 'Source
document' as a title, I want to have another combo box appear to categorize
the 'source document' as 'flight summary', 'log summary', etc.
I messed around with coding to make this combo box visible, but it became
difficult to figure out what events to tie this into:
If Title.Value = "Source Documents" Then
Item_Name.Visible = True
Else
Item_Name.Visible = False
End If
This worked fine when used as an after update event for the Title until you
needed to put the same code on many form-level events...
If you understand what I want to do, is there an easier way to think about
doing this?
some titles may be further categorized as items. The events have only one
Title descriptor, which you select with a combo box which looks up about
twenty different title categories for you to select from. However, there are
2 categories of Titles that I want to further categorize as items and have
another combo box lookup a list of items...for instance if you select 'Source
document' as a title, I want to have another combo box appear to categorize
the 'source document' as 'flight summary', 'log summary', etc.
I messed around with coding to make this combo box visible, but it became
difficult to figure out what events to tie this into:
If Title.Value = "Source Documents" Then
Item_Name.Visible = True
Else
Item_Name.Visible = False
End If
This worked fine when used as an after update event for the Title until you
needed to put the same code on many form-level events...
If you understand what I want to do, is there an easier way to think about
doing this?