Lock drop down menus

[Simon]

I have a drop down menu, Is there a way that once i have selected the
drop down recored it want . that it will Lock it from being changed
again for that recored


Thanks

Simon

 

[Graham R Seach]

Simon,

Do you mean a menu item or a drop-down list (combo box)?

If you mean a menu item, then in the procedure that the menu item calls:
CommandBars("CommandBarName").Controls("MenuItemName").Enabled = False

If you mean a combo box:
Private Sub cboMyCombo_AfterUpdate()
Me.cboMyCombo.Locked = True
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia