Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: How can I know recordset count changed

Geek News

How can I know recordset count changed
Tony 12/22/2008 8:31:05 PM
Hi guys,

I have some details information of a record which is placed in the form
footer in a continiouse form. I should hide the footer if there's no record
in the form. since it's a multi-user form, the record cout might changed by
other user and I may get the latest records by refreshing manually.

The thing is, if I refresh it and no more records appears, I don't know the
change. Form_Query is not triggered.

Any ideas will be appreaciated!

Thanks!
RE: How can I know recordset count changed
Tony 12/22/2008 8:49:01 PM
Sorry, what I mean to say is,

if there's no records in the form, (it's all deleted by other user, and I
refresh the form manually.) how can I know that? Form_query is not triggered.

"Tony" wrote:

[Quoted Text]
> Hi guys,
>
> I have some details information of a record which is placed in the form
> footer in a continiouse form. I should hide the footer if there's no record
> in the form. since it's a multi-user form, the record cout might changed by
> other user and I may get the latest records by refreshing manually.
>
> The thing is, if I refresh it and no more records appears, I don't know the
> change. Form_Query is not triggered.
>
> Any ideas will be appreaciated!
>
> Thanks!

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net