Results 1 to 2 of 2

Thread: !Simple! Access 2003 Form w/ SubForm Query Issue/help

Threaded View

  1. #1
    Join Date
    Jul 2006
    Posts
    2

    !Simple! Access 2003 Form w/ SubForm Query Issue/help

    tblModelColor: 4 fields, MODEL, COLOR, START, STOP
    vwModelList: contains all the tblModelColor fields
    vwModelList_subform: form in linear form of vwModelList
    frmModelColor:
    • No Header
    • Detail: Has sub form query that has the 4 fields from tblModelColor
    • Footer: has a cboModelName, cmdShowAll, cmdRunQuery

    Problem:I'm trying to allow the user to pick from list MODEL or type in a wildcard like Model_* . Which should return all Like MODEL_* in the Details section of the form.

    Currently when I select the MODEL or type MODEL, I get a parameter dialog box. Forcing me to input the MODEL again, before displays all the MODEL.

    Question: How can I get all like MODELS to automatically populate in the the sub query form with out making the user double enter or select and then enter the text again in the dialog box.

    I've attached the mdb (very small).

    Thx for the assistance.
    Attached Files Attached Files

Posting Permissions

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