Hi all!
I have been going over the different posts in here and trying many different things to get this to work...I have a frmOrders with a sfrmOrderDetails. If the product in the orders details form is not in the drop down list you can double click and it opens the products form to add the product. The user then closes the form and clicks the product list but it is not refreshed. I have tried so many different events now and have failed to get the list to refresh. If i click outside of the products drop down into the quantity field and then back it will refresh but otherwise it doesnt. I was thinking that placing the me.requery on the gotfocus event may work but no luck. Any help would be much appreciated.
Thx
I have been going over the different posts in here and trying many different things to get this to work...I have a frmOrders with a sfrmOrderDetails. If the product in the orders details form is not in the drop down list you can double click and it opens the products form to add the product. The user then closes the form and clicks the product list but it is not refreshed. I have tried so many different events now and have failed to get the list to refresh. If i click outside of the products drop down into the quantity field and then back it will refresh but otherwise it doesnt. I was thinking that placing the me.requery on the gotfocus event may work but no luck. Any help would be much appreciated.
Thx
