Filter by Form disabled

In an Access 97 application I have changed a form from a 'normal' form
with custom toolbar, menubar and shortcut bar to a model popup form.
The shortcut menu has Filter by Form on it and used to work fine, but
since changing the form type it is now disabled.

Any ideas why please

Dave

re: Filter by Form disabled

dave@k2computers.co.uk (Dave Griffiths) wrote in
news:56242347.0410160231.3dcf5c4a@posting.google.c om:
[color=blue]
> In an Access 97 application I have changed a form from a
> 'normal' form with custom toolbar, menubar and shortcut bar to
> a model popup form. The shortcut menu has Filter by Form on it
> and used to work fine, but since changing the form type it is
> now disabled.
>
> Any ideas why please
>
> Dave
>[/color]
Any modal form blocks the application from moving the focus to any
other form report, menu, etc. Since the filter by form opens a copy
of the form to gather your filtering info, it cannot get focus.

--
Bob Quintal

PA is y I've altered my email address.

re: Filter by Form disabled

Aha, thanks for that - understood.

But have you any ideas about how I could work round this?

Thanks
Dave

Bob Quintal <rquintal@sPAmpatico.ca> wrote in message news:<1097934494.yoVhz66FsR2Kzly4vAcC9Q@teranews>. ..[color=blue]
> dave@k2computers.co.uk (Dave Griffiths) wrote in
> news:56242347.0410160231.3dcf5c4a@posting.google.c om:
>[color=green]
> > In an Access 97 application I have changed a form from a
> > 'normal' form with custom toolbar, menubar and shortcut bar to
> > a model popup form. The shortcut menu has Filter by Form on it
> > and used to work fine, but since changing the form type it is
> > now disabled.
> >
> > Any ideas why please
> >
> > Dave
> >[/color]
> Any modal form blocks the application from moving the focus to any
> other form report, menu, etc. Since the filter by form opens a copy
> of the form to gather your filtering info, it cannot get focus.[/color]

re: Filter by Form disabled

dave@k2computers.co.uk (Dave Griffiths) wrote in
news:56242347.0410170113.a7dc26f@posting.google.co m:
[color=blue]
> Aha, thanks for that - understood.
>
> But have you any ideas about how I could work round this?
>
> Thanks
> Dave
>[/color]
Remove the modal property of the form?? Other than that, there
isn't much you can do.



[color=blue]
> Bob Quintal <rquintal@sPAmpatico.ca> wrote in message
> news:<1097934494.yoVhz66FsR2Kzly4vAcC9Q@teranews>. ..[color=green]
>> dave@k2computers.co.uk (Dave Griffiths) wrote in
>> news:56242347.0410160231.3dcf5c4a@posting.google.c om:
>>[color=darkred]
>> > In an Access 97 application I have changed a form from a
>> > 'normal' form with custom toolbar, menubar and shortcut bar
>> > to a model popup form. The shortcut menu has Filter by Form
>> > on it and used to work fine, but since changing the form
>> > type it is now disabled.
>> >
>> > Any ideas why please
>> >
>> > Dave
>> >[/color]
>> Any modal form blocks the application from moving the focus
>> to any other form report, menu, etc. Since the filter by form
>> opens a copy of the form to gather your filtering info, it
>> cannot get focus.[/color]
>[/color]



--
Bob Quintal

PA is y I've altered my email address.

re: Filter by Form disabled

On 16 Oct 2004 03:31:33 -0700, dave@k2computers.co.uk (Dave Griffiths) wrote:
[color=blue]
>In an Access 97 application I have changed a form from a 'normal' form
>with custom toolbar, menubar and shortcut bar to a model popup form.
>The shortcut menu has Filter by Form on it and used to work fine, but
>since changing the form type it is now disabled.
>
>Any ideas why please
>
>Dave[/color]

IIRC filter by form should work if the form is modal, but not if the form is a popup.
Set Popup to False / Modal to True and it should work.

Wayne Gillespie
Gosford NSW Australia