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

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" wrote:

> 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
>
>
>

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

david

"Devlin" <(E-Mail Removed)> wrote in message
news:479D72A6-5550-41DA-9432-(E-Mail Removed)...
> 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" wrote:
>
>> 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
>>
>>
>>

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!

"David Cleland" wrote:

> 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
>
>
>