Event procedure to change record (1 Viewer)

M

mounty76

Registered User.

Local time

Yesterday, 20:31

Joined

Sep 14, 2017

Messages

341

• Jul 17, 2019

• #1

Hello!

I have two yes/no fields in a table, these are shown in a form next to peoples names in the form, one yes/no column is called 'On' and the other is 'Off'.

Any ideas on how to make an on click event procedure so that when I click 'On' the 'Off' yes/no cell for that record is automatically set to False?

Thanks very much

 

M

mounty76

Registered User.

Local time

Yesterday, 20:31

Joined

Sep 14, 2017

Messages

341

• Jul 17, 2019

• #2

Figured it out! Thanks

Me!Off = False

Easy when you know how!

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 20:31

Joined

Aug 30, 2003

Messages

36,124

• Jul 17, 2019

• #3

Thanks for updating the thread with your solution. Is it always on or off, never both? If so, why two fields instead of one?

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 04:31

Joined

Jul 9, 2003

Messages

16,274

• Jul 17, 2019

• #4

I thought you might find this useful.

The Second video on my website here shows you how to ensure that out of a set of check-boxes, one checkbox always remains checked.

Loop Through a Set of Controls