View Single Post
  #3  
Old April 28th, 2010, 08:56 PM posted to microsoft.public.access.forms
SteveG
external usenet poster
 
Posts: 36
Default Sub form validations

Thanks Daryl...option 2 would seem to fit better with this project...I kmow
how to make the fields in the sub form invisible, but how would I make them
disappear when a field in one of the sub forms becomes dirty?
--
SteveG


"Daryl S" wrote:

SteveG -

You can make the other tabs invisible while data is incomplete. If you want
to progress logically from tab 1 to tab 2, etc., then you can start with all
tabs invisible other than tab 1. Then when the user hits the Save button and
data is valid, then you can make tab 2 visible (and hide tab 1 if you want).
Or you can start with all tabs visible, but on any change to a field you can
make the other tabs invisible until the Save button is pressed and data
validated.


--
Daryl S


"SteveG" wrote:

Hi All:
I am pretty new to this stuff, but need to figure out how control data flow
in a form with a bunch of tabbed sub forms. I will try to see if I can make
this make sense:
We have a foirm with a bunch of tabbed sub forms used for dataentry. We need
to control thins so that if someone enters data in a field of one of the sub
forms, they cannot exit the form without clicking the save button and
therefor cannot click on another tab in the master form until the data is
saved. For instance, tab a calls for first name and last name. Once data is
entered into either field, the user cannot click on tab b which would be for
credit limit until the data in tab a has been saved.

Hope this post makes some sense to someone

TIF

--
SteveG