Disable button if no data is entered into text box

M

May

on the Form Properties, set enable = no to make it default

under the textbox at AfterUpdate, key in the following
if not isnull(textboxname) then
command_button.enabled = true
end if

my suggestion for you is, make everything except the close
the form button enable = flase
after policy ID has been key in then
if not isnull(textboxname) then
command_button.enabled = true
every control.enabled = true
end if

May
MCP in Access and SQL Server
 
Top