I want to enable a combo box on a form for a new entry only. What's the best way to achieve this?
I want to enable a combo box on a form for a new entry only. What's the best way to achieve this?
test for a new record.
If Me.NewRecord then
'enable combo
else
'disable combo
end if
Only allow input to combobox on a New Record?
Could use code in form Current event:
Me.comboboxname.Enabled = Me.NewRecord
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks guys, got that working now.
In addition how to I allow copy from the the disabled combobox?
Text cannot be selected. Could have button code grab the combobox value.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.