Requery Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asif - 18 Jun 2007 10:43 GMT

I have a listbox that displays Date and Quantity above the listbox is
a textbox that holds the year . On the After Update event of this
textbox I have the following expression

=Text14.Requery

When I change the entry in the textbox from 2007 to 2008 the listbox
contents is emptied as there is no data for 2008.

Now I've placed another listbox in this form and have tried to apply
the same syntax as above for this listbox but nothing happens when I
change the year.

Any suggestions??

Thanks

Reply to this Message

Steve Schapel - 18 Jun 2007 11:06 GMT

Asif,

I believe it is not correct to have the = sign in the context of the
code you showed. Should be:
Me.Text14.Requery

But what is Text14 anyway? Is it the name of the Listbox?

What is the Row Source of the Listbox? Is it a query that uses the
value of the Textbox in the Criteria?

How about the second Listbox? Does it also have a reference in its Row
Source query to the Textbox?

Signature

Steve Schapel, Microsoft Access MVP

> I have a listbox that displays Date and Quantity above the listbox is
> a textbox that holds the year . On the After Update event of this
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

Asif - 18 Jun 2007 12:14 GMT

> Asif,
>
[quoted text clipped - 31 lines]
>
> - Show quoted text -

Thanks Steve for your reply, after read your response I looked at the
rowsource for the listbox and yes there was I criteria specified,
which I did not apply to the second listbox.

Its working well now, thanks for the tip

Regards

Reply to this Message