Having A Query open a Form

[KM]

Is there a way to have a query open the corresponding form rather than
in datasheet view? I am creating a database that will run off of a
switchboard as the users do not know anything about access and I want
to make this as easy as possible for them.

Any help would be greatly appreciated.

KLM

[Rick Brandt]

"KM" <vz******@verizon.net> wrote in message
news:54**************************@posting.google.c om...

Is there a way to have a query open the corresponding form rather than
in datasheet view? I am creating a database that will run off of a
switchboard as the users do not know anything about access and I want
to make this as easy as possible for them.

Forms can open queries. Queries cannot open forms (or anything else) as they
have no code events.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[fredg]

On 7 Feb 2004 14:47:43 -0800, KM wrote:

Is there a way to have a query open the corresponding form rather than
in datasheet view? I am creating a database that will run off of a
switchboard as the users do not know anything about access and I want
to make this as easy as possible for them.

Any help would be greatly appreciated.

KLM

You're trying to work it backwards.
Make a form using the query as it's recordset.
Open the form to see the results of gthe query.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Roger]

I'm not sure what you're try to do but you could (air code)
create a function
public function openForm(strForm) as integer
openform = 1
docmd.openform(...,strform,..)
end function
select *,openForm("frmXYZ") as formToOpen FROM tblabc...
vz******@verizon.net (KM) wrote in message news:<54**************************@posting.google. com>...

Is there a way to have a query open the corresponding form rather than
in datasheet view? I am creating a database that will run off of a
switchboard as the users do not know anything about access and I want
to make this as easy as possible for them.

Any help would be greatly appreciated.

KLM

[Bas Cost Budde]

Rick Brandt wrote:

Forms can open queries. Queries cannot open forms (or anything else) as they
have no code events.

Mwa, you challenge me: if you have a function called from the query
(that is perfectly legitimate) that function could open any form.

Never mind that. (Practical use, anyone?)
--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl