Dlookup annoying issue

[Lupson2011]

Hi



I am trying to use the Dlookup function to put an amountawarded figure in a field on a form, based on a choice of LFURN from a combo box on the same form.

Here is the code I have used in the 'afterupdate' event on the combo box

Private Sub LFURN_AfterUpdate()
AmountAwarded = DLookup("AmountAwarded", "LocalFoodProjects", "LFURN='" & LFURN & "'")

So essentially, the figure shown in the AmountAwarded field is AmountAwarded figure in the LocalFoodProjects table, based on the LFURN being the same in that table and what is chosen the current form.

When i run it, it gets no errors, but doesnt do anything, certainly doesnt populate the AmountAwarded box?

I am sure its just a little tweaking but if anyone can help that would be greeat

Thanks

bagpuss

[Rainlover]

Try

Me.AmountAwarded = DLookup("AmountAwarded", "LocalFoodProjects", "LFURN='" & LFURN & "'")

[Lupson2011]

Nope, still doesnt do anything sorry.

[RuralGuy]

What is the bound column of your ComboBox? Have you put in a breakpoint and hovered over the values to see what you are getting?

[Lupson2011]

Aha, I have changed the bound columns value from 1 to 2 (which now would include the AmountAwarded figure

This seems to have done the trick. Thanks for the tip pointing me in the right direction!

[orange]

What is the name of the combobox?

Are you getting an error message? Any values?

[RuralGuy]

Glad we could help.

[Lupson2011]

thansk orange, Rural Guy helped me solve it

[orange]

I guess I'm still typing too slow. The question was there, I started to think and write, but got there a little late... again.

Glad you got it resolved.