Re: Setting query parameters from a query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In the Criteria line of the Query's grid, put the line

Forms!NameOfOpenForm!ControlName.Value

Notice the "!" between different objects, and dots "." to denote properties.
Don't confuse them!

HTH

Smokey smith wrote:
>I need step by step instructions on how to get parameters for a query from a
>form that is completed by a customer.
>
>Your help will save me fropm insanity
>
>Peter

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200511/1
.

Relevant Pages

  • Re: eml Extension
    ... > Please give me step-by-step instructions. ... >> HTH ... >> Microsoft MVP-FrontPage ... >>> the text of eml file using Internet Explorer. ...
    (microsoft.public.frontpage.programming)
  • Re: Jumping into middle of instruction
    ... instructions, ... Sure it once was used to confuse brainless disassemblers ... ... [called as ext-mem OS PM32 Function from RM} ...
    (comp.lang.asm.x86)
  • Re: software package disappeared in GPO after access rights change
    ... the same permissions. ... Refer to http://support.microsoft.com/kb/216359 for instructions how to ... The intention was to disable installation of that package for now, ...
    (microsoft.public.windows.server.active_directory)
  • Re: A simple issue to you... Please Help.
    ... the instructions in this article. ... HTH, ... Brad ... >I import *.inf and made a component, ...
    (microsoft.public.windowsxp.embedded)
  • Re: SuSE 9.1 no sound whatsoever
    ... > Mr. Land adjusted his/her tin foil beanie and asbestos underwear to ... > HTH ... I read these instructions several times...they just didn't make sense ...
    (alt.os.linux.suse)