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

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

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

-Tom.
[color=blue]
>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[/color]