[AccessD] Closing form problem

[Kaup, Chester]

Thanks for the ideas. I will evaluate and proceed.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Wednesday, January 06, 2016 2:53 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Closing form problem


<<Maybe not have a default vale and make it a required field?>>

 Make the field dirty in the OnCurrent event.

 Set it to null, then back to the default value.

 Or use can use Rocky's trick.   It would be far better though to have the
user explicitly indicate when they are done and just use a command button.

 As for why the original error, it's exactly for the reason the error states; you can't carry out the action at that particular time.  

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, January 06, 2016 03:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Closing form problem

That work great if a value is entered in the last field. If the user selects the default value it fails. Maybe not have a default vale and make it a required field?

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Wednesday, January 06, 2016 11:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Closing form problem

You can close the form if you do it from the AfterUpdate event of the text box - I just tried that here.

Doug
--
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

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