Populating a list box

[George Papadopoulos]

Hello everybody

I have a form which displays technician repair records from a table. The
underlying table contains a foreign key which points to pertaining records
in a second table. I would like to have a button on the form, which when
pressed opens a new form to display those records.
After looking at the available controls, I believe that a listbox control
would do the job. The problem is that I do not know how to populate such a
control. Could somebody help me clarify this.

thx, in advance

George Papadopoulos

 

[Michel Walsh]

Hi,


The easiest way is to specify its RowSource property with an SQL
statement (or a table, or a saved query), the list will then be the content
of the table (including the filtering effect of WHERE clauses, as example)
filling the associated properties accordingly (such as the number of
columns, ColumnCount, ColumnWitdths, ... ). You can also use the Control
Wizard to start a new control in a form (and further refine it "by hand")...


Hoping it may help,
Vanderghast, Access MVP