I have a table named kidsjobs. There is a field in this table named kharidar which is not a required field.
A form has been made on this table. It has a control box named kharidar, bound to the above mentioned field named kharidar. I want to design the form so that the user cannot close or move to next record, unless the controlbox kharidar in the form is not blank. i dont want to make the field in the table required. The names are actual. Please help me have the vba code or anything that works to get this task.
thank you