My DoCmd.SearchForRecord command stopped working

I have a dropdownlist that has 4 columns but only 3 are 'visible' the first one is an ID, and after update I have the following code run.

DoCmd.SearchForRecord acDataForm, "new_order_thingy", acFirst, "[OrderID] = " & Me.Combo112.Column(0)

This used to get the record pertaining to the OrderID, I am not sure what I did but I somehow broke it. I don't get an error but it doesn't retrieve any data.

It does pass the correct value in Me.Combo112.Column(0) when I MsgBox it out.

Any help/suggestions would be appreciated.

Than开发者_JS百科ks

I suggest you place a breakpoint in your code. Then, change the value in the combo, and in break mode, hover the mouse over the variables.
This will also show you if the event is really fired.
Sometimes the link between the event and the procedure is lost (e.g. when you rename the object).

The Form.DataEntry was set to YES, it should have been set to NO ... don't get why but thats what was causing my error.