Results 1 to 2 of 2

Thread: Listbox Problem

  1. #1
    Join Date
    May 2006

    Unanswered: Listbox Problem

    Windows XP Pro

    I have a form named “COMMUNICATIONS” connected to a flat-file table named “communications” There is a textbox named “unit” which contains an employees Id number and another textbox named “ActivityCode”.

    Additionally, a listbox named” list0” which is connected to a query to show all employees that are available for call; this is identified by (ActivityCode.value =”10-41”)

    The second listbox named”list1628” that is also connected to a query which shows units that are assigned to a call and are no longer available for calls.

    When the employee is assigned to a call he/she still show up in “list0” as an available unit. In short if a unit is in list1628 then it doesn’t need to be in list0 and vice versa. I have included the sql code for each listbox

    List0 code:
    SELECT Communications.Item, Communications.Unit, Communications.Received, Communications.AGENCY, Communications.[Duty Officers], Communications.[DAY WORD]
    FROM Communications
    WHERE (((Communications.Received) Is Not Null) AND ((Communications.Completed) Is Null) AND ((Communications.[Activity Code])="10-41"));

    SELECT OnSceneQuery.Item, OnSceneQuery.Unit, OnSceneQuery.Location, OnSceneQuery.Arrived, OnSceneQuery.[Activity Code], OnSceneQuery.[DAY WORD], OnSceneQuery.Operator
    FROM OnSceneQuery
    ORDER BY OnSceneQuery.Item;

    Any help will be appreciated.

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    See how this does you.
    Izy has a nice twin list example that may be easier to apply in this case.

    pootle flump
    ur codings are working excelent.

Posting Permissions

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