468,484 Members | 2,113 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,484 developers. It's quick & easy.

Lookup Fields

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.
Jun 25 '07 #1
2 1949
hyperpau
184 Expert 100+
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.
Jun 26 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
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.
Hi Lance,

It depends on what you mean by this.

Are you looking at the table as a recordset ? If so then the answer is know. How are you planning to access the table object. You could open it as a TableDef in code and then the properties will be available but what action are you then taking and what triggers this action.

You will need to give a lot more information about what you are trying to do.

Mary
Jun 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Richard Coutts | last post: by
3 posts views Thread by my-wings | last post: by
1 post views Thread by Zachary Turner | last post: by
1 post views Thread by Paul H | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.