Combo Box doesn't update fields

[nicksource]

I have a Combobox so the enduser can search and select items for the form below it rather than clicking the arrows for Next/Previous.

However I have an issue with DLookup queries.

My Combobox is called 'F_ComboBox' (I use F_ in my forms to indicate it's a form textfield and not from a table).

My first field in the form, called 'F_ProdID', I want it to select the rows ID from the Combobox option selected. So it's simply:

=[F_ComboBox]

Which works fine, it shows the ID for what I selected... but when I do this to show my ProductName...

=DLookup([ProductName], 'Products', [ProdID] = [F_ComboBox])

Or the same but using the first textfield:

=DLookup([ProductName], 'Products', [ProdID] = [F_ProdID])

It loads once but if I select another item out of the Combobox it doesn't change, it just stays on the last result. So the query works, just doesn't refresh when a new item is picked from the ComboBox.

Am I doing something wrong?

Thanks,
Nick.

 

[Moniker]

In the AfterUpdate event of the combobox, put a Me.Refresh (where the Me keyword is the form). That will force it to display correctly.

I'm not sure