User Profile

Collapse

Profile Sidebar

Collapse
Simon Jans
Simon Jans
Last Activity: Feb 20 '07, 02:15 PM
Joined: Feb 15 '07
Location: Dubai
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Simon Jans
    replied to search form using combo boxes and relates tbls
    in Access
    OK it's working now

    thanks a lot

    Simon
    See more | Go to post

      Leave a comment:

    • Simon Jans
      replied to search form using combo boxes and relates tbls
      in Access
      Hi NeoPa thanks for replying so quikly

      using the formfiltering dbase as example I would like to see the account type (customer or supplier) in the filtered account type combo box instead of the index number (0,1 or 2)

      by the way in the example you use a value list but I need to use a linked table as rowsource but I suppose that doesn't make a difference

      regards
      Simon
      See more | Go to post

        Leave a comment:

      • Simon Jans
        started a topic search form using combo boxes and relates tbls
        in Access

        search form using combo boxes and relates tbls

        Hello
        I'm having serious troubles creating a seach form showing data from multiple tbls, I'll try to explain my problem using a simple example
        by the way I'm using Acces 2003

        Code:
        tblEquipment 
equipment ID
description
brand ID
price 
...

tblBrand 
brand ID 
brand
        these 2 tbls are linked using the brand ID (one to many)

        now I trying...
        See more | Go to post
        Last edited by NeoPa; Feb 16 '07, 01:41 PM. Reason: Tags
        No activity results to display
        Show More
        Working...