Updating fields

[David Cleland]

Hi

I have a problem. I have a form and I want to update a field based on the
value of another field. The problem is the value is the second column. Ie
the field is a loop showing two fields but I am to use the second column not
the first.

if Me!User (but the second column of the lookup) = Yes then etc ?

David

 

[Guest]

David,

Can you explain what you mean by "the field is a loop?" Are we talking
about a combo or list box with multiple columns? Or, are you concantinating
two fields into one?

 

[David Cleland]

Sorry I meant the field is a lookup with two columns visible.

david

 

[Guest]

David,

I assume that you are talking about a combo box on a form. To reference
another column besides the bound column you simply specify the column index.

Example:

MyVariable = Me.MyComboBox.Column(1)

So based on your question you would place this code in the AfterUpdate event
for MyComboBox.

Example:

Sub MyComboBox_AfterUpdate()
MyVariable = nz(Me.MyComboBox.Column(1),"")
End Sub

I hope this helps. Good luck!