Search results

  1. J

    HELP! Need to use Combo Box to filter records in Access Form

    I'm trying to use a combo box to filter out records on an Access form. So the user will only see the records that have the same Organization ID as they selected in the combo box. I have tried SQL statement(s) and that has not proven successful. Any suggestions from the VB side? I've tried using...
  2. J

    Filter From with Combo Box

    I am sorry...I gave you the working SQL statement, here is the one with the filter in it... SELECT Tbl50K.CurrentBalance, Tbl50K.BegBalance, Tbl50K.Org, [tbl Organization ID].Office, Tbl50K.EntityId, Tbl50K.TP, Tbl50K.Emp, TblEmployees.LastName, TblEmployees.NickName, Tbl50K.DtAsgnd...
  3. J

    Filter From with Combo Box

    Here is the full SQL Statement: SELECT Tbl50K.CurrentBalance, Tbl50K.BegBalance, Tbl50K.Org, [tbl Organization ID].Office, Tbl50K.EntityId, Tbl50K.TP, Tbl50K.Emp, TblEmployees.LastName, TblEmployees.NickName, Tbl50K.DtAsgnd, Tbl50K.DateClosed FROM [tbl Organization ID] INNER JOIN (TblEmployees...
  4. J

    Filter From with Combo Box

    I am trying to filter out what fields the user sees on the form by using a combo box. The use selects a value in the combo box and will see only the records related to that value. I am using a SQL statement and tried the following code under the necessary field...
Back
Top Bottom