Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    30

    Unanswered: limit date items in combobox

    I have a combo box that displays a list of dates that a student can be registered for. The combo box retreives the dates from tblPhotodates and stores the value in Contacttable. I need to limit the dates in the combobox so that once 15 students in Contacttable have been registered the date no longer appears in the combo box. I know I need a WHERE clause in the row source for this but not sure how to get started.
    Last edited by crosseydlobster; 06-09-11 at 13:09.

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    It sounds to me like you need to count the number of times the date appears in the ContactTable then join the result to the PhotoTable. To do this, create a query that has the date from the ContactTable and a Count(*). The result should be:

    06/7/11---1
    06/8/11---3
    .
    .
    .

    Then create a query that joins the count with the PhotoTable and join on the date. That way you can select all of the dates that are less than 15.

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
  •