Code in Access

[dikdikdikdik]

I am new student for MS Access 2010.


As above form, How to create code programming on Access2010? Please help to advise me.

Describe:
When I alreadr checked on Checkbox of chk1 to chk9 then i click on Cmdbotton, will show "Complete database" in txtbox. but have some not-checked on the one of checkbox(chk1 to chk9) after click on Cmdbotton then will show "Not complete database" on Txtbox.

[June7]

Review http://office.microsoft.com/en-us/ac...010341717.aspx

Try VBA code in button Click event procedure:

If Me.chk1 = False Or <do same for other 7 checkboxes> Or Me.chk9 = False Then
   Me.Txtbox = "Not complete database"
Else
   Me.Txtbox = "Compete database"
End If

Or

booFinish = True
For i = 1 To 9
    If Me.Controls("chk" & i) = False Then
        booFinish = False
    End If
    If booFinish = False Then
        Me.Txtbox = "Not complete database"
    Else
        Me.Txtbox = "Compete database"
    End If
Next

[dikdikdikdik]

Hello June7, Thank you very much for your kindly help ^___^