frankbutcher
Registered User.
- Local time
- Today, 10:54
- Joined
- Aug 6, 2004
- Messages
- 192
Hi all.
I have a form with a sub form. I have a button on my form which takes the info within the sub form (a list of materials) and then puts them into a report.
Within the sub form (datasheet view), there is a field for Quantity, which I change for each item.
What I would like is to check each quantity field before opening the report.
For example, if there are 5 items in the sub form, it would check each 5 items in the sub form to ensure that a quantity has been added for each.
I am having trouble with the code to check the quantity number, and it will only check the itme that is selected.
Hope this makes sense and someone can help.
Many thanks.
Frank.
I have a form with a sub form. I have a button on my form which takes the info within the sub form (a list of materials) and then puts them into a report.
Within the sub form (datasheet view), there is a field for Quantity, which I change for each item.
What I would like is to check each quantity field before opening the report.
For example, if there are 5 items in the sub form, it would check each 5 items in the sub form to ensure that a quantity has been added for each.
I am having trouble with the code to check the quantity number, and it will only check the itme that is selected.
Hope this makes sense and someone can help.
Many thanks.
Frank.
