Disable, then Enable Some Buttons....

[Torn39]

Hi Access Experts,

I've got a form I'm designing that I'm not sure how to set up the correct programming for. Hopefully some of you can help...(please!)

I've got five buttons on the right hand side that fire off different files to be saved on the A: (one at a time of course). These are different queries from another query. My issue is I don't want these buttons active until after the users have entered some information on the left side (essentially until after the initial "organizing" query is run). Depending on what the users put in, some of these other buttons might not be active pre-query or post query.

Can someone help the newbie out?

Thanks

Drew

 

[SBendBuckeye]

Use the After Update event for your left side information to put code something like this:

Private Sub LeftSideControlName_AfterUpdate()

If Button1 ValidationCodeIsTrue Then
Button1.Enabled = True
Else
Button1.Enabled = False
End If

Repeat with other appropriate validation code

End Sub

Good Luck!