I have a main form with a subform in it. When the main form is opened it generates an expense id number. the subform contains the expense information for that id number. the subform has its own table that is connected to the mainform's table via the expense id. the subform can have multiple entries and each one is distinguished by an id number.
i am having trouble canceling out of the current expense. i want to click a cancel button and have it delete all info from the subform's table that relates to the current expense id and also have delete the related info from the main form's table, but when i click on the button it tells me "No Current Record". any ideas?
i am having trouble canceling out of the current expense. i want to click a cancel button and have it delete all info from the subform's table that relates to the current expense id and also have delete the related info from the main form's table, but when i click on the button it tells me "No Current Record". any ideas?