display table fields in a list box

[ekta]

Hi:

I have a combobox that shows my database tables. I want that when user selects a table, all the fields in that table should be displayed in the listbox. How can I do that?

Thanks,

Ekta

 

[doran_doran]

sample...

I seen some sample database regarding what you want to do. please visit following.

http://www.rogersaccesslibrary.com

Good Luck

 

[pbaldy]

Choose Field List as the row source type.

 

[Kicker]

Assuming you know how to additem to the listbox,


Dim n As Integer
for n = 0 to rst.fields.count - 1
listbox.additem rst.Fields.Name
next n