Validation of controls & subform -- on tab control

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I need to create some validation on a tab control that checks if all
"required fields & subforms" have been selected/received data.

Here's what I have:
- 2 tables
- 1 main form & 1 subform

The mainform contains:
- 3 pages... to be more exact...

- page 1 has 2 controls (textbox and combo)... both of them are required
fields
- page 2 has 1 combo plus 4 textboxes... only the combo is a required
field... once a selection is made from the combo, the other 4 textfields are
automatically populated (so I don't worry about them)
- page 2 also has a subform... I must make a selection (at least one value)
from the subform
- page 3 has 3 checkboxes... they aren't required

Here's what I need to achieve:
- I start w/ page 1... if I leave any of the 2 required controls "empty" I
cannot move to page 2 or 3
- once on page 2 (process as on page 1), I cannot navigate off the page
unless the combo and subform have a value
- page 3 doesn't have restrictions... if left blank, no problem

Could anyone please provide me some more detail as to how I can throw "error
messages" and change the background color of those controls that are empty?
Once completed, background color changes back to original color (white).

I'd really appreciate any help in this matter.
 
-----Original Message-----
I need to create some validation on a tab control that checks if all
"required fields & subforms" have been selected/received data.

Here's what I have:
- 2 tables
- 1 main form & 1 subform

The mainform contains:
- 3 pages... to be more exact...

- page 1 has 2 controls (textbox and combo)... both of them are required
fields
- page 2 has 1 combo plus 4 textboxes... only the combo is a required
field... once a selection is made from the combo, the other 4 textfields are
automatically populated (so I don't worry about them)
- page 2 also has a subform... I must make a selection (at least one value)
from the subform
- page 3 has 3 checkboxes... they aren't required

Here's what I need to achieve:
- I start w/ page 1... if I leave any of the 2 required controls "empty" I
cannot move to page 2 or 3
- once on page 2 (process as on page 1), I cannot navigate off the page
unless the combo and subform have a value
- page 3 doesn't have restrictions... if left blank, no problem

Could anyone please provide me some more detail as to how I can throw "error
messages" and change the background color of those controls that are empty?
Once completed, background color changes back to original color (white).

I'd really appreciate any help in this matter.

--
Thanks,
Tom

Tom,
Click to expand...
I have read your problem and unfortunately I don't have
the expertise to help, however I think you can help me.
Can you send me the code or tell me how you populated the
textfields once a selection is made from the combo. This
is very similar to my problem as detailed below on this
site under my name.
I know this doesn't solve your problem but maybe one day
I'll know enough to contribute.
Thanks
Ken a
 
I doubt that... just must "unlock" it though once downloaded... right-click
and select unlock (or unblock).

If that won't work for you, shoot me and email and I'll sent you the file.

skydiveREMOVEMEtom @ erolsREMOVEME.com
 
Back
Top