Quote:
Originally Posted by Lance Williams
How can you programatically tell if a field in a table is a lookup field? I am looping through the fields collection and I want to see if any fields are lookup fields.
Is there a property, or something taht will tell me if the field is a lookup field.
I need to do this at the table level and not at the form level because if a field is a lookup field then I do certain things in the code.
BTW, lookup fields suck.
Yes there is. Normaly, in the datasheet view of the table, the field would display a drop down arrow indicating that it is a drop down combo box look up.
Secondly, you can go to the design view, and on each field, go to the
lookup tab on the properties below. if it is text box, it is not lookup, if it is combo box, then it is lookup.
