Re: Query and recordsource

From: Jeff (JeffKlein_at_Associatedoffices.com)
Date: 09/08/04 

Date: Tue, 7 Sep 2004 23:21:42 -0500

Steve, Thanks for the info.
This works OK but......When the query returns a empty recordset I get an
hourglass for a few seconds and then it exits access. Any ideas?

"[MVP] S.Clark" <steve.clark_NOSPAM@FMSInc.com> wrote in message
news:ucay9dSlEHA.3452@TK2MSFTNGP15.phx.gbl...
> Syntax needs to include FORMS![formname]!txb_Name
>
> Replace formname with your form name.
>
> --
> Steve Clark, Access MVP
> FMS, Inc.
> www.fmsinc.com/consulting
>
> "Jeff" <JeffKlein@Associatedoffices.com> wrote in message
> news:ONplA5QlEHA.1904@TK2MSFTNGP09.phx.gbl...
> > I have a query that prompts for [txb_Name]. On my form is a txb_Name
> > textbox. and a cmdbutton that sets the forms recordsource to the query.
> > When I click the command button I am still being prompted. Why?
> >
> >
>
>