TechRepublic|Forums|Web Development

Web Development

General discussion

  • Creator
    Topic
  • June 6, 2001 at 5:52 am #2115635

    access 97 query

    Locked

    by vincent.lukban@adidasus · about 22 years, 10 months ago

    here’s my situation. i have a listbox that displays data from a query. the query pulls from 5 different tables. i am trying to code combo boxes below the listbox to change the values of the columns in the listbox, but am not successful. is it possible to edit values a query returns, and if so, will it update the table it pulled from? new to vba here :-).

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • June 6, 2001 at 8:58 am #3681206

      access 97 query

      by donq · about 22 years, 10 months ago

      In reply to access 97 query

      What you want to do is a common practice. Each Combo box has a “Row Source” property that can be set to any select statement (or query).

      If you are changing column count or format (width)as well you’ll need to update the Column Count, Column Widths, Bound Column, and List Widthe properties – etc.

      Build little queries tat do what you want and copy their SQL to the clipboard (and/or Row Source property of a Combo box). Past desired results into a Case Select based on user choices from your List Box’s After Update event tp populate any or all variable combo boxes (along with any other revised property settings).

  • Author
    Replies
Viewing 0 reply threads