Results 1 to 5 of 5

Thread: Extra step

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Extra step

    I have a parameter query that uses the field RSID from the table tblRSDirectory. Records in the RSID field can have from one to four characters. Typical example: 1N5G. The characters represent four levels of organization, from highest to lowest. My parameter criterion reads: Like [Enter Bde Code: ] & "*". Bde Code refers to the first character

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Extra step

    Any chance your main parameter query is linked to other queries that also use the same parameter. Thus when you input the parameter for the first query, the links to other queries may cause it to parameter again.

    How are you launching this query such that the parameter query window opens?
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Extra step

    I'm just monkeying around with the data using the query builder (design view). I fiddle with the parameters, then click on the Run icon. The situation I describes occurs when I click to switch from design view to datasheet view.

    As for your first question: This is a very small database. It has two tables, and this is the only query.

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Extra step

    Try looking at <post#=220577>post 220577</post#> and corresponding thread to see if that helps.
    Regards,

    Gary
    (It's been a while!)

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Extra step

    Thanks, Gary. I'll have to study that one for a while. I appreciate your time!

Posting Permissions

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