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]

Re: refreshing records

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"
<mark.reed75@nt lworld.com> wrote:
[color=blue]
>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
>[/color]