OH I miss C!!

I am struggling to make the data I have collected in my text boxes appear in
a list box that is linked to a temporary table. The Idea is to write each
set of text boxes as a record to be added to the listbox (called Display) and
to the table called tblTempTable. Can anyone help?

First, you can bind the listbox to a table, so why not just write the values
to the table, and then the values will "appear" in the listbox...

If you use code to add records to the table, then you will need to tell
ms-access to "re-load" the listbox. You can do that with

me.MyListBox.Requery.

As a general rule, using bound controls does do all the "heavy" work for
you, but you got to learn how to work with them....

For "grids" in ms-access, you might also consider a continues sub-form. Here
is some screen shots of both a listbox, and continuous form...as often one,
or the other can be used (ie: they are often interchangeable).

http://www.members.shaw.ca/AlbertKal...icles/Grid.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

Hi ADK,
Thank you for replying. I had thought it might be easier to write the data
to the table instead. I will try that tomorrow. Check on me tomorrow if you
can. The grid idea is interesting. The screenshots certainly give the idea
it is flexable. I really do need this code going ASAP - You know how it goes

Thanks again,
Acad

Albert D.Kallal wrote:
First, you can bind the listbox to a table, so why not just write the values
to the table, and then the values will "appear" in the listbox...

If you use code to add records to the table, then you will need to tell
ms-access to "re-load" the listbox. You can do that with

me.MyListBox.Requery.

As a general rule, using bound controls does do all the "heavy" work for
you, but you got to learn how to work with them....

For "grids" in ms-access, you might also consider a continues sub-form. Here
is some screen shots of both a listbox, and continuous form...as often one,
or the other can be used (ie: they are often interchangeable).

http://www.members.shaw.ca/AlbertKal...icles/Grid.htm