User Profile

Collapse

Profile Sidebar

Collapse
Lobius
Lobius
Last Activity: Jul 1 '08, 02:40 PM
Joined: Jul 1 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Lobius
    replied to Filtering a list box using a variable?
    in Access
    Excellent! It works thanks a lot, i've been playing around with applyfilter and things for hours with no progress.
    See more | Go to post

      Leave a comment:

    • Lobius
      started a topic Filtering a list box using a variable?
      in Access

      Filtering a list box using a variable?

      Hi, To put it simply I need to filter information in a list box according to a particular field in a table.

      I have tables "Table1" and "Table2". Table1 contains primary key "Key1", this is a foreign key in Table2.

      At the moment I have used the following code to show all the records in Table2 in a list box (name List_Box1):

      List_Box1.rowso urce = "SELECT [Table2].[ID],[Table2].[Information],[Table2].[Date],[Table2].[Key1]...
      See more | Go to post
      No activity results to display
      Show More
      Working...