Requry problem

Rivers

New member
Local time
Today, 23:47
Joined
May 3, 2004
Messages
5
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
 

Users who are viewing this thread

Back
Top Bottom