Get column head name from list box?

[joelmeaders]

Is there any way to return the column head (String) from a listbox?



I am building a section in a program for higher security users to add new fields to certain combo boxes. The list box is set as table/query and dynamically loads different tables based on user input.

I have everything else worked out except retrieving the column headings so I can dynamically save new values into tables. The tables do not have the same field names.

[pbaldy]

Using the Column property and referring to row 0 should return the heading:

?Forms!frmCharges.lstPayments.Column(3,0)
OrderDate

OrderDate is the heading in the 4th column.

[joelmeaders]

Using the Column property and referring to row 0 should return the heading:

?Forms!frmCharges.lstPayments.Column(3,0)
OrderDate

OrderDate is the heading in the 4th column.

It was right in front of my face the whole time. Thanks a lot!!

[pbaldy]

No problemo!