By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

Saving a Record - Access 2000

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.