[AccessD] Restrict data entry from form into table

Andy Lacey andy at minstersystems.co.uk
Thu Jul 22 14:31:15 CDT 2004


Chester
If you set an index on the date plus the second field and make it Unique
won't that do it? They'll still be able to select the 'wrong' value from the
dropdown but Access will error when they try to save that record. You can
have an error handler to intercept the errror and give a neater message if
you want to.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Kaup, Chester A
> Sent: 22 July 2004 17:14
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Restrict data entry from form into table
> 
> 
> I have a form for data entry into a table. The first field, 
> date, is automatically filled in from a selection on another 
> form. The second field is a drop down list box. The third 
> field is to enter a numeric value. For any given date I need 
> to let the user only select a particular item from the drop 
> down list in the second field once. Is this possible through 
> indexing or some other method? I am drawing a blank here. Thanks
> 
> Chester Kaup
> Information Management Technician
> IT-MidContinent/MidContinent Business Unit
> CTN 8-687-7415  
> Outside 432-687-7414
> 
> No trees were killed in the sending of this message. However 
> a large number of electrons were terribly inconvenienced. 
> 
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
> 




More information about the AccessD mailing list