Jim Dettman
jimdettman at verizon.net
Thu Jun 7 07:56:46 CDT 2012
That's the ticket... A forms record set may or may not be there yet in the open event. Your not guaranteed it's available until the OnLoad. Everyone likes to put stuff in OnOpen because it's cancelable, where as OnLoad is not. But the form is really not up and running yet. Its simply started to open and it's still getting itself together through that event. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, June 07, 2012 12:17 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report Well, there's a theory. In the open if there's an openarg (a PK passed by a calling program) I do a find first else I just move to the last record. I could move the whole shebang from the open event to the Load event. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, June 06, 2012 9:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report Can you even use that command in the Form_Open event? I didn't think the recordset was loaded at that point. Thought you had to wait for the Load event. Charlotte Foust On Wed, Jun 6, 2012 at 12:55 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > How could an mde generate this error on the line of code: > > DoCmd.GoToRecord , , acLast > > MTIA > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.bchacc.com > > > www.e-z-mrp.com > > > Skype: rocky.smolin > > > > -----Original Message----- > From: Victor Garcia [mailto:victor.hugo.garcia at prometalmexico.com] > Sent: Wednesday, June 06, 2012 10:03 AM > To: rockysmolin at bchacc.com > Subject: E-Z-MRP(tm) Error Report > > Error: 2499 - You can't use the GoToRecord action or method on an > object in Design view. > In: frmSOPackingList.Form_Open > > > > -- > 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