looking up certain tagged textboxes on a form for null/empty

[BPBP]

Hello,

Is there a way to tag certain textboxes on a form?

I'm trying to test for certain null/empty textboxes(tagged) at the beforeupdate event of the form. If they are empty, cancel the update without undoing, then setfocus on the empty field.

A sample code to reference would be great.
Something like a For all controls, do while loop.

Thanks.
BP

 

[pbaldy]

  Dim ctl As Control
  For Each ctl In Me.Controls
    'do your thing
  Next ctl

 

[BPBP]

Thanks for the reply.

I mean the tagging part. I dunt require all controls to be filled. Just some controls which are tagged.

And also is there a way to tag them(controls, not the underlying table fields)?

 

[CEH]

Paul gave you the short version Check this post and see the detail...
http://www.access-programmers.co.uk/forums/showthread.php?t=161254&highlight=ctl+Me.Controls

 

[pbaldy]

Sorry, I guess I misunderstood this:

A sample code to reference would be great.
Something like a For all controls, do while loop.

 

[BPBP]

I got it to work. THanks All.