Looping Through Controls to Check Values

[mcktigger]

Hi hoping someone can help with this

I have a number of products on a form where the user selects "Yes" in a combo box to indicate if they want special prices for that product. If they select yes then they need to enter the qty. They can do this for multiple products. Once finished they click a link (Submit Request) which sends an email to their manager requesting authorisation (this part all works fine)

What I want to do is check if any of the combo boxes are set to Yes but a zero or Null is entered in the any of the corresponding qty fields, the Submit Request link is automatically disabled until each qty is completed. I think I need to do a DO WHILE or FOR EACH loop but not sure how to do this or where I would put the event.

I hope this makes sense. Really appreciate any help.

[rpeare]

Are your items in a bound or unbound form, and are they in a subform or are they on the main form. The method really relies on how you're storing your data and what your user interface looks like.

For instance if you're using an unbound control that you could make use of the TAG property to check if values meet a certain criteria. If you're going to be cycling through items in a subform you'd likely want to create a dynamic dataset and cycle through those records.

[mcktigger]

Hi

They are on a bound form. Not in a subform but they are on a tabbed page.

Thanks

[rpeare]

on the button that sends the request you'd just have to have something like this

dim sMsg as string
sMsg = ""
if Special_Price1 = "Yes" and nz(Special_Price1_Qty) = 0 Then sMsg = "Value missing for Special Price Marked yes on Item " & <field name with special price item description> & vbcrlf
blah blah for each check

Msgbox "Can not forward order.  These items are in error: " & vbcrlf & vbcrlf & smsg

I don't know how your form is set up but you can do some things to mitigate the amount of code you have to write but i"d have to see a sample of the database to go in that direction.