Hi again everyone......i've attached a database which i've received help with here recently but one more issue has popped up. If you navigate to the Submit A Work Order form and enter your name and selected time, you then go to the subform and select the items you need. All works fine. However, if you pick an item and then pick a second item, the relevant cost will appear to the right for both items, but if you then delete the second item and try to click back into the combo box for the first item, you get a database error. Is it possible to make the txtCost textbox go blank if the combo box selection is deleted ?.
I know if you delete the selection from the combo box and then delete the cost from the text box then this will solve the problem, but unfortunately some of the people using this aren't doing that and it's causing a bit of a problem.
arnelgp i will totally understand if you want to pass
I know if you delete the selection from the combo box and then delete the cost from the text box then this will solve the problem, but unfortunately some of the people using this aren't doing that and it's causing a bit of a problem.
arnelgp i will totally understand if you want to pass