Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Location
    Alabama
    Posts
    37

    Unanswered: [RESOLVED]Help with Expression [Forms]![Form46]![month]

    Access 2000

    I have an “unbound” form with a list box, a text box, and a combo box. The list box’s Row Source Type is a Query. The query’s criteria come from the textbox and a combo on the form. Once the information is entered into textbox and the combo box a macro is set to run on the combo box’s “On Change” event, which runs a Do Command Refresh Page. This expression [Forms]![Form46]![month] is an example of how I am setting the criteria in the query; which when I put the month “May” in the text box passes that information to the query’s design view “Month column. The combo also works the same way. What I need is to know what type of expression do I use so that I can use “All “ in the text box and combo box.

    Thank You

    Carbo


    I worked it out.. Hope this helps someone else.

    Answer:

    1. Like [Forms]![Form46]![month] is the modification to the query expression
    2. Enter * in the combo or text box
    Last edited by mshelley1; 05-12-06 at 12:08.

  2. #2
    Join Date
    May 2006
    Location
    Alabama
    Posts
    37

    [RESOLVED]Help with Expression [Forms]![Form46]![month]

    I worked it out.. Hope this helps someone else.

    Answer:

    1. Like [Forms]![Form46]![month] is the modification to the query expression
    2. Enter * in the combo or text box

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •