I have a search and sub form that shows vendor data. I want to be able to click (FRM_SearchMulti) and pull up that record in another form (frm_sub_record_update) so the user can update category and spend numbers.
I have the following:
FRM_SearchMulti - main search form
qry_cat subform - I need user to edit or add new categories for vendors. They can have multiple.
qry_spend subform - User to edit spend
frm_sub_record_update - this form includes both above into a tab view so user can view easier.