By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,877 Members | 1,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,877 IT Pros & Developers. It's quick & easy.

Lookup Fields

P: 2
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
Share this Question
Share on Google+
2 Replies


hyperpau
Expert 100+
P: 184
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
Expert Mod 10K+
P: 14,534
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.