[AccessD] Menu form changes app behavior?

[Janet Erbach]

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
>