many controls

questionit

Hi,

If there are so many controls on a form - check boxes, radio buttons, texboxes, etc.

How can i know if any of these are changed - thier value changed, etc

If any of these is changed ... then do something.

Thanks

Twanne

Right click on the item and add some code. Something like build... I think (in dutch is "gebeurtenis opbouwen")

questionit

Twanne

I said i have items not just a single item.

There are 10s of controls , how can you set onChange event or something with everyone ?

Ofcouse a better method is needed

Quote:

Originally Posted by Twanne

Right click on the item and add some code. Something like build... I think (in dutch is "gebeurtenis opbouwen")

missinglinq

Is there one thing you want to do if any of the controls change, or are there different things you want to do, depending on which controls change?

Linq

questionit

I want to do one thing if any of the controls change

Quote:

Originally Posted by missinglinq

Is there one thing you want to do if any of the controls change, or are there different things you want to do, depending on which controls change?

Linq

missinglinq

This will immediately run the code with the input of a single character into any field

Expand|Select|Wrap|Line Numbers

 Private Sub Form_Dirty(Cancel As Integer)

 'Code to run goes here

End Sub

This will run the code when the record is saved if a single character has been entered into any field

Expand|Select|Wrap|Line Numbers

 Private Sub Form_BeforeUpdate(Cancel As Integer)

 'Code to run goes here

End Sub

If you only want the code to run when a record is being edited, not when a new record is being entered, use this code

Expand|Select|Wrap|Line Numbers

 Private Sub Form_BeforeUpdate(Cancel As Integer)

 If Not Me.NewRecord Then

  'Code to run goes here

 End If

End Sub
 
Private Sub Form_Dirty(Cancel As Integer)

 If Not Me.NewRecord Then

  'Code to run goes here

 End If

End Sub

Linq

questionit

HI Linq

The code you have give works fine. What if i want to check other things like change of check-box value or radio button value?

If their value change then do something ......Again i have so many of these on the form.

Thanks

Quote:

Originally Posted by missinglinq

This will immediately run the code with the input of a single character into any field

Expand|Select|Wrap|Line Numbers

 Private Sub Form_Dirty(Cancel As Integer)

 'Code to run goes here

End Sub

This will run the code when the record is saved if a single character has been entered into any field

Expand|Select|Wrap|Line Numbers

 Private Sub Form_BeforeUpdate(Cancel As Integer)

 'Code to run goes here

End Sub

If you only want the code to run when a record is being edited, not when a new record is being entered, use this code

Expand|Select|Wrap|Line Numbers

 Private Sub Form_BeforeUpdate(Cancel As Integer)

 If Not Me.NewRecord Then

  'Code to run goes here

 End If

End Sub
 
Private Sub Form_Dirty(Cancel As Integer)

 If Not Me.NewRecord Then

  'Code to run goes here

 End If

End Sub

Linq

missinglinq

The code you've got will work for any change in your record, including checkboxes and radio buttons. If you want to perform something when the value of a particular control (checkbox, radio button or whatever) you have to put the code in the BeforeUpdate sub for the particular control.

Hey there! Do you need Microsoft Access / VBA help?

many controls

re: many controls

re: many controls

re: many controls

re: many controls

re: many controls

re: many controls

re: many controls

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/other

/bytes/about