combo box value

[Jason]

I thought that I could use a combo(1) to retrieve the 2nd field in the
combobox.rowsource but this generates #error.

Thanks,
J.

 

[Douglas J. Steele]

Use

combo.Column(1)

 

[fredg]

I thought that I could use a combo(1) to retrieve the 2nd field in the
combobox.rowsource but this generates #error.

Thanks,
J.

Well, perhaps you only have 1 column, not 2.
Or perhaps you used the wrong syntax.
Or perhaps ........
Hard to tell with the little information you have provided.

 

[Jason]

I'll try Douglas's reply as it has the missing syntax.

 

[Jason]

Thanks,

Now I can get rid of
Form_OnCurrent
Fieldname = dlookup(fieldname1)

Fieldname1_Afterupdate
Fieldname = dlookup(fieldname1)