Web Development

General discussion


access 97 query

By vincent.lukban@adidasus ·
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 :-).

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

access 97 query

by donq 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).

Related Discussions

Related Forums