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

refreshing records

P: n/a
Hi all,
I have 2 tables, times & dates
times includes amongst others, 2 fields, date in & day
dates includes date & day.

I have set the lookup property (combo box) on [times].[day] to SELECT
DISTINCT dates.day FROM dates WHERE (((times.[date in]=dates.date)));
This works fine for the first record I fill in but on the next record, it
remembers the previous field. If I click on tools - refresh it then works ok
until the next record.

Is there any way that I can get it to refresh once I have filled in the date
in field?

Cheers,
Mark
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I'll confess to being groggy and not quite following what you're
doing. But I'll respoond anyway. ;-)

If you need to Refresh the data source for your combo box, there are
a variety of ways to go about it (in VBA). Which is appropriate
depends on your particular need (warning: air-code, written when
groggy):

- You could try Me.ComboBoxName.Refresh in the AfterUpdate event of
the combo box.

- You could try Me.ComboBoxName.Refresh in the OnCurrent event of the
form.

Also be aware that there's a difference between "Refresh" and
"Requery".

Hope that gets you on the right track.

-Matt
On Mon, 23 Feb 2004 08:13:46 -0000, "Mark Reed"
<ma*********@ntlworld.com> wrote:
Hi all,
I have 2 tables, times & dates
times includes amongst others, 2 fields, date in & day
dates includes date & day.

I have set the lookup property (combo box) on [times].[day] to SELECT
DISTINCT dates.day FROM dates WHERE (((times.[date in]=dates.date)));
This works fine for the first record I fill in but on the next record, it
remembers the previous field. If I click on tools - refresh it then works ok
until the next record.

Is there any way that I can get it to refresh once I have filled in the date
in field?

Cheers,
Mark


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.