Field Attributes??

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I am trying to create a form that creates a filter. On this form I have a
listbox that holds all the fields in the table. when a user clicks the field
in the listbox, I can get the Data Type of the selected field, but I'd like
to know if that field in the table has a RowSource associated with it. I want
to get that RowSource and populate a second listbox with that RowSource. I
want to do this dynamically and not use a hard-coded field name because in
the future, there may be more fields added to the table. Is there a way to
find that information?
I hope I am explaining this well enough. Thanks for any help!
 
I figured out how to get the RowSource:
strRowSource = MyField.Properties("RowSource")

If the field doesn't have a rowSource attached to it you get an error so you
have to trap the error.
 
Back
Top