refreshing records

[Mark Reed]

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

[Matthew Sullivan]

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