Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Wrong data showing (2003)

    Sorry, folks, but I've gotten out of practice over the past three months and I can't remember <img src=/w3timages/censored.gif alt=censored border=0>! I've built a form with a query as its datasource. The query pulls from two tables: tblCompanies and tblBusinessType. Each company has a "type": manufacturing, construction, physician, etc. One of the fields on the form is BusinessType (control source: tbl.BusinessTypes.BusinessType). This is a data-entry form

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Wrong data showing (2003)

    The Column Widths property is in the Format tab of the Properties window, not in the Data tab.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Wrong data showing (2003)

    Hello, Hans

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Wrong data showing (2003)

    Hi Lucas,

    What are the following properties of the combo box?
    In the Format tab:
    - Column Count
    - Column Widths
    In the Data tab:
    - Control Source
    - Row Source Type
    - Row Source
    - Bound Column

    As far as the tab behavior is concerned, select View | Tab Order. If you added the combo box later than the other controls, it may have ended up after the others in the tab order.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Wrong data showing (2003)

    Re: Tab order: Fixed that

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrong data showing (2003)

    Lucas,

    Column Count should be 2
    Column widths should be 0, X where X is the width you want for your list.

    This suppose that the name of bussinesstype is in the second field.
    Francois

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrong data showing (2003)

    Addition :
    Row Source should be : tblBussinesType

    And you should remove the table tblBussinesType from your query. It is not necessary.
    Francois

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Wrong data showing (2003)

    Fran

Posting Permissions

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