| re: Saving a Record - Access 2000
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]
| 
