[AccessD] Datasheet view validation

Thanks for the reply Susan!
Unfortunately, when I do this, it does not force the user to enter data into
the field. Because of the join I described below, the "required field"
requirement would only work if the user actually entered data in the field
that had the "required field" setting in the first place.

Any other ideas?

Thanks!
JR

-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net]
Sent: Monday, April 04, 2005 9:03 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Datasheet view validation

Well, the easiest way -- which might not be the best way for you -- would be
to simply make that field Required at the table level. If the value truly is
required when you enter the record, this works OK and is a simple solution.

Susan H.

Hi All,

I have a form that has as its record source a query that joins two tables
together in a one-to-many relationship (outer join). I am displaying this
form as a datasheet.
The query is designed so that there will never be any records that match on
the "many" side when it is first opened. The query only displays two
columns. One from the "one" side and one from the "many" side.
As I have it now, a user could close the form without entering data into the
field from the "many" side, thus not creating a record on the "many" side.

How can I verify that the user has entered data in the field from the "many"
side for every record that is displayed? I don't want to restrict the row
order in which they enter data but I do want to make sure that the field for
each row is filled in before they close the form.

Thanks!
JR




This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.