Setting the Enabled property of Command button conditionally

[bbrazeau]

I have a command button on a form that uses info from a textbox and a combobox. I need to make sure there are values in the controls. Could someone show me how I can set the Enabled property of the command button to be false unless the other 2 controls have data? I'd like to do htis with macro commands as I'm not to well versed in VBA. Thank You.

[Robeen]

The easiest way to do what you're trying to do is through VBA.

It is not complex at all - and it might give you a really good opportunity to dip your toes in the water.

You'll get plenty of help here with VBA.

[TinaCa]

The great thing about VBA is that its what I call programming by multiple choice . For your issue try an if statement. In the example below when you type the me. (don't forget the dot) Access will show you all the name of the controls in a drop down list, just type the first letter of the name of your textbox or combo box. i.e. If me.textbox = [enter your info here] And me.combobox = [enter your info here] Then me.button.enabled = false.

Try the me. a few times - it's fun!! (oh replace textbox with the name of your text box and same for combo box and button).

[rpeare]

I'd take Tina's suggestion

In the ON EXIT property of your two required fields have the code:

if not isnull(me.firstfield) and not isnull(me.secondfield) then
   me.buttonname.enabled = true
else
   me.buttonname.enabled = false
endif

where firstfield, secondfield and button name are all the names of the objects on your form