[AccessD] Menu form changes app behavior?

Stuart McLachlan stuart at lexacorp.com.pg
Tue Mar 31 14:36:15 CDT 2015


No, it doesn't force a save of the dirty record, it discards the change.

On 31 Mar 2015 at 8:22, Janet Erbach wrote:

> I'll try that.  Doesn't 'Me.requery' do the same thing, though?
> 
> On Mon, Mar 30, 2015 at 3:27 PM, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> 
> > The last record is still dirty and the "accept" state has not been
> > updated.
> >
> > Try a "Me.Dirty = False" at the start of the procedure to force the
> > save.
> >
> >
> >
> > On 30 Mar 2015 at 14:59, Janet Erbach wrote:
> >
> > > I am trouble shooting an app that uses a switchboard menu.  While
> > > I'm trouble shooting, I open the app in design view to write my
> > > code, test my forms and queries, etc.  Everything is working fine
> > > that way.
> > >
> > > As soon as I run the menu form and begin testing the app the way
> > > the end user sees it, the results I get change.
> > >
> > > Specifically:  the user types in a part # and a machine #;  the
> > > query inserts, say, 6 records into a temp table.  A form comes up
> > > that displays the records in that temp table;  the user can select
> > > the records to process with an 'accept' checkbox.  When the user
> > > clicks 'submit', all records with 'accept=true' should be selected
> > > and processed.
> > >
> > > This works fine when I open the app in design mode:  I select 6
> > > records, and 6 records are processed.  When running this function
> > > through the main menu, though, only 5 out of 6 are being selected!
> > > It's as if the last 'accept' checkmark is not being posted to the
> > > table.  I issue a 'Me.requery' to the form as soon as the 'submit'
> > > button is checked to post all the records, but it's not working.
> > >
> > > I have no idea why this is happening.  Any ideas where I can look?
> > >
> > > Janet Erbach
> > > --
> > > 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
> 




More information about the AccessD mailing list