Unable to add record

[Guest]

I have a front end/back end database. 2-6 users are signed in at a given
time. The primary form lets them log calls. They hit the 'initiate call'
button which creates a new record and logs the time. When they hang up, they
hit the 'stop call' button which logs the stop time and they go ahead and
type comments in a memo field. Next call comes in and they hit 'initiate
call' again, so on.

The problem they're having is occasionally they get an 'unable to add
record' error when they try to 'initiate call'. I'm wondering if this isn't
caused by the form keeping a record open while additional ones are being
added. So perhaps user1 takes a call and logs it and then doesn't get
another call for a while whereas the others are continuing to take calls. At
a certain point it just puts a stop to new records until user1's call is
closed.

Is there a way I can have the stop call button save the record (and thereby
close it) without advancing to the next (or new) record?

 

[Guest]

Assuming you are using subforms, this shouldn't be the case. You are
creating a record, at 'Initiate Call', and then the user should only be
working with their own record. Once they 'Stop Call', and enter notes, you
update the record and reset the form. There wouldn't be anything open until
the next call is initiated.

You could look at adding a form change, after the 'Initiate Call', to insure
the user is only working with their record. Not sure that Requery would be
enough. You may have to have a form/subform change.