I want to dispaly the combo box or list box with
data from table on user request. means when a user
press "F4" or "ALT+F1" then the combo box should
is visible with data from table and selected value
should be placed in corresponding text box .
Printable View
I want to dispaly the combo box or list box with
data from table on user request. means when a user
press "F4" or "ALT+F1" then the combo box should
is visible with data from table and selected value
should be placed in corresponding text box .
Private Sub mnuShowCombo_Click ()
combo1.clear
'
'Code to populate combo1 with appropriate Data
'
combo1.visible=true
combo1.enabled=true
end sub
This assumes that you have an entry in your menu named mnuShowCombo that is triggered by "F4". If you are trying to trap for "F4" from a particular object then use the ObjectName_KeyUp event to trap for "F4".
Hope it helps
Hunter