Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012

    Question Unanswered: Basing one combo box on another

    Hi everyone,

    I've been having some trouble with a form where the items on one combo box will depend on whats chosen in the previous combo box. I've followed the instructions at Basing one combo box on another - Access - but it still doesn't seem to be working.

    First combo box, jobtype is a simple drop down list (not linked to a table or anything)

    The second one runns a query using data from a a table containing two columns; jobtype and job. The criteria in the jobtype field is
    and I've set the bound column property to 2 to get the job column from the query.

    Ideally, the results of this query should populate the combo box, but when I select it on my form (in form view) I just get an 'Enter Perimeter Vaule' dialog box.

    Any ideas? I'm stumped.

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    The parameter prompt is Access telling you it can't find something. Make sure the form is open, and that the form and control names are spelled correctly.

Tags for this Thread

Posting Permissions

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