Detect if lookup field in table

[danvlas]

Hi guys,

Is there anyone that knows how to determine (in code) if a field from a table (in a remote database, of course!) is a damn lookup field and if yes, what its source is?


Thanks for your help (if I figure it out myself, I'll post back)




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[danvlas]

Never mind.

Found out that I can inspect field's RowSourceType property.
If it's not a lookup field, an error occurs and that's enough for what I need now.

On Error Resume Next
test = fld.Properties("RowSourceType")
If Err.Number = 0 Then
MsgBox "WOW...It's a lookup field! Who did it???"
End If




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[straybullet]

LOL - I love the message!

Let them hate - so long as they fear... Lucius Accius