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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Keep field enabled after closing db 8
enable/disable text box based on 3 combos 2
Buttons Enabled or Disabled 2
Make record only on "ADD" button 1
Enabling/disabling command button based on DCount 1
toggle button nightmare 3
Infopath Button Disable 0

Top