Loop through controls on a form

[CanNeverThinkOfaName]

Hi,

Can someone tell me if its possible to loop through all of the controls on a form so I can tell if the user has entered any text in any of the textboxes/comboboxes etc?

I'm having a problem that when one user saves a particular record and then another user access that record and changes it, the record is saved as a new record instead of being updated in the table

Any suggestions?
It's probably so simple but I can't see it at the moment!

Thanks

Maria

 

[ItIsHardToProgram]

Have a look at your Allowedit property maybe.. ?

 

[CanNeverThinkOfaName]

I'm sorry I'm not sure what you mean?

 

[ItIsHardToProgram]

I was just asking if your allowedit property was set to yes...... if it isnt, you will not be able to edit any record.

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=5010

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

This may be useful:
HOW TO: Automatically Detect If a Form Is Being Edited in Access 2000

http://support.microsoft.com/kb/210334/en-us

And Me.NewRecord will allow you to check if a record is being added.

 

[NvrSaDi]

Attached code will cycle through all of the specific type of controls on a form. You can insert a variety of conditons or tests within the "if" statement.

Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is TextBox Then
ctl.Locked = False
End If
Next
For Each ctl In Me.Controls
If TypeOf ctl Is ComboBox Then
ctl.Locked = False
End If
Next
For Each ctl In Me.Controls
If TypeOf ctl Is CheckBox Then
ctl.Locked = False
End If
Next

 

[CanNeverThinkOfaName]

thanks very much
got it working now!