By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,945 Members | 1,354 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,945 IT Pros & Developers. It's quick & easy.

Validation of sub form records

100+
P: 374
Hi all,

I have a subform on my main form which displays as a single form.

Using custom navigation buttons I move through the records in the subform related to it's parent.

I can do basic form validation fine and validate that boxes within the subform are filled in correctly. However how do I set up the following validation:

Within subfrmAction each record has a value entered for "txtActionCompletedDate".

So basically if a record exists within the sub form I want to check txtActionCompletedDate has a date. The catch for me, is there are x amount of records how do I check all records have txtCostFig filled in one go.

Edit:

I found a similar post and I think missinglinq asked why the validation was not done prior to record save.

My scenario is that an action will be assigned to a person. Then the manager will come back close to the proposed end date of the action and assign the actual completed date.

Validation will then be used to enable a button to be clicked if all actions have a completed date to recommend the overall project to be closed. If a completed date is not entered in a record then the button will be disabled until it is added.
Aug 2 '10 #1

✓ answered by munkee

I have given dao a bit of a go and used the find first to find the records associated in the subform against th emain form ID number and then test the fields to find the first null field. If no nulls are found then the button will fire the event if not the button will error and tell the user why.

Share this Question
Share on Google+
1 Reply


100+
P: 374
I have given dao a bit of a go and used the find first to find the records associated in the subform against th emain form ID number and then test the fields to find the first null field. If no nulls are found then the button will fire the event if not the button will error and tell the user why.
Aug 2 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.