Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set check box value based on another checkbox

Status
Not open for further replies.

barit

Technical User
Jun 29, 2004
38
CA
I want to automatically set the checkbox value of field called "Invited" to true, if another checkbox on the form called "selected" = true.

I have tried

If ((Me.Selected=True)) Then
Me.Invited = True

Nothing happens. Any suggestions would be greatly appreciated.
 
How are ya barit . . . . .

Code:
[blue]If Me!Selected Then Me!Invited = Me!Selected[/blue]
And if Selected is false?


Calvin.gif
See Ya! . . . . . .
 
Thanks so much TheAceMan1 for the suggestion.

I ended up using the following

If Me!Selected = True Then
Me!Invited = Me!Selected
End If

Selected = True is part of the criteria in the sql select statement for the form. I am filtering for records where the selected field =true.

Anyway, I truly appreciate your suggestion. It put me on the right path finally and I now have solved one more issue with this form.

Regards
Barit
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top