Solved Subform Error (1 Viewer)

Emma35

Registered User.
Local time
Yesterday, 21:48
Joined
Sep 18, 2012
Messages
455
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 😢
 

Attachments

  • Test (2).accdb
    3.6 MB · Views: 103

mike60smart

Registered User.
Local time
Today, 04:48
Joined
Aug 6, 2017
Messages
1,899
Hi

Easiest option is a Delete button for item not required
 

Attachments

  • Test (2).zip
    314.7 KB · Views: 103

Emma35

Registered User.
Local time
Yesterday, 21:48
Joined
Sep 18, 2012
Messages
455
mike60smart....thank you it works great

Em x
 

mike60smart

Registered User.
Local time
Today, 04:48
Joined
Aug 6, 2017
Messages
1,899
Hi Em

Notice that I changed the View of the Subform from a Datasheet to a Continuous Form

x
 

Users who are viewing this thread

Top Bottom