View “Access 97 form troubles”
– – – posted on – – 6/30
– – – now closed for this post
The problem with what we’re trying to do is:
the user is to view and fill out the form in ADD MODE which doesn’t do the calculation of finding the highest ‘job number’ and designating the next one. It does this calculation in EDIT MODE.
Our first solution was to use a macro in the switchbox to open the form in ‘edit mode’ to do the calculation And open the form in ‘add mode’ so the user can do what needs done…Problem…well…this works perfectly…except the calculation takes longer(over 20,000 records) to finish than it does for the ‘add mode’ form does to load.
So, our first thought was ‘try to halt the ‘add mode’ form until the calculation completes… If there is a way, it’s not one that we tried. We tried some basic VB code entered directly into the form… no go …my code knowledge is still limited to verrrrry basic stuff and my partner’s in next to zip. Maybe a macro ofsome kind…no luck
