I have form for product sales entry and there is control [Status] which is 1 to 4. Product for data entry has to be status 1 and when item is available for sale I have to change the status to 1 before data entry. How can i change the status while in the form for data entry. Right know I open the other form for the status change I then come back for the form for data entry, but also it does not get update unless I close the form first and open again. Please help.