Help with Listbox (Adding More Than One Field From A Access Table)
Try:
List1.AddItem datcntry.Recordset.Fields("country") & " - " &
datacntry.Recordset.Fields("currency")
--
Good Luck,
Joe
------------------------------------------------------------
Before posting a question, see if it's already been answered:
http://www.deja.com/home_ps.shtml
(use *vb* in the Forum field to limit search)
------------------------------------------------------------
Quote:
> I have an simple table in access with several fields and I want to put
more
> than one field in the listbox for each record. I can get the first field
> (Country) in the listbox but I can not get the second one (Currency) in
the
> same listbox. I would like to seperate these two fields with a hyphen.
> Here is the code I have so far:
> Private Sub Form_Activate()
> datcntry.Recordset.MoveFirst
> Do While Not datcntry.Recordset.EOF
> List1.AddItem datcntry.Recordset.Fields("country")
> datcntry.Recordset.MoveNext
> Loop
> End Sub
