I have a Customer form with a subform showing the customer locations which is the main form for the application. On this form, I have an unbound combo box with a list of currently open orders, which pops open an order form when an order is selected from the list.
I put a requery command on the OnEnter event of the combo box to ensure that any new, shipped, and cancelled orders by other users are refreshed on and off the list each time it is used. (Forms!frmMain!SearchOrder.Requery)
As soon as the combo box requeries, the Customer location subform returns to the first record. I have even written code to record the location that the form is on before the requery, and then navigate back to that location on the subform after the requery... a silly workaround I know. It works when I step through it in debug mode, but as soon as I remove the breakpoint and just let it run, it doesn't work anymore.
Has anyone ever come across this before and figured out how to fix it?
I am tearing my hair out!
Thanks in advance
Yvonne