Saving a Record - Access 2000

[Andrew]

In Access 2000, I have a form for Horse and a subform for Stable which
contains a combo box showing empty stables. If I enter a StableNo and
a DateIn (but no DateOut), the underlying query correctly shows that
stable as being unavailable. However, if I simply move to another
Horse record (without closing/reopening the form), the stable is still
showing vacant.

I have tried using the SaveRecord command in the AfterUpdate of the
DateIn box, but the whole thing only works if I close the form and
re-open it.

I am trying to figure out how to save the record "better"! Andrew

[Tom van Stiphout]

On 27 Apr 2005 05:24:50 -0700, "Andrew" <an**********@tiscali.co.uk>
wrote:

You need to requery the combobox after the save, for example in the
<form>_AfterUpdate event.

-Tom.

In Access 2000, I have a form for Horse and a subform for Stable which
contains a combo box showing empty stables. If I enter a StableNo and
a DateIn (but no DateOut), the underlying query correctly shows that
stable as being unavailable. However, if I simply move to another
Horse record (without closing/reopening the form), the stable is still
showing vacant.

I have tried using the SaveRecord command in the AfterUpdate of the
DateIn box, but the whole thing only works if I close the form and
re-open it.

I am trying to figure out how to save the record "better"! Andrew