Retrieve column names for form RecordSource

  • Thread starter Thread starter jtertin
  • Start date Start date
J

jtertin

How can I refer to the names of the columns in the form's RecordSource
table from VBA?

Something like: Me.RecordSource.Item([columnnumber].Name (which is
obviously not correct).
 
Me.RecordsetClone.Fields([columnnumber]).Name

However, I can't think of a legitimate reason to need to do that!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Data entry to table from a form 1
Recordsource of a form 1
Data entry VBA 1
Datasheet caption for yes/no field can't be changed 1
Form Recordsource on Query 1
Can't reference one subform from another. 10
Dirk Goldgar help please!!! 2

Back
Top