I am trying to requery a subform
The macro code to do this is DoCmd.RunMacro "mcr_new_customer_number_of_boards", 1
The subforum it rm_new_customer_number_of_boards
The subform is made of this query called qry_account_count
SELECT Sum([tbl_board]![fld_board_cust_no]=[Forms]![frm_new_customer]![customer_number]) AS [Number of Boards]
FROM tbl_board INNER JOIN tbl_customers ON [tbl_board].[fld_board_cust_no]=[tbl_customers].[fld_cust_no];
frm_new_customer is the main form.
When this macro runs it runs on another sub-form
The macro code to do this is DoCmd.RunMacro "mcr_new_customer_number_of_boards", 1
The subforum it rm_new_customer_number_of_boards
The subform is made of this query called qry_account_count
SELECT Sum([tbl_board]![fld_board_cust_no]=[Forms]![frm_new_customer]![customer_number]) AS [Number of Boards]
FROM tbl_board INNER JOIN tbl_customers ON [tbl_board].[fld_board_cust_no]=[tbl_customers].[fld_cust_no];
frm_new_customer is the main form.
When this macro runs it runs on another sub-form