how to filter a subform from a form (1 Viewer)

ivonsurf123

Registered User.
Local time
Yesterday, 20:48
Joined
Dec 8, 2017
Messages
69
I have a question on how can I filter fields from Subform to a form in a query, also does anybody know the format to use as numeric field in a query, like # for Date? Please help. Thank you.

ID is a numeric field that is in a Subform called subfrm_GCDS_Operations_Positions_Fills_Log_New1,

The main form is this query, Main form is called frm_CDS_Operations_Fills_Log_New

Me!subfrm_GCDS_Operations_Positions_Fills_Log_New1.Form.RecordSource = "SELECT tbl_GCDS_Operations_Positions_Fills_Log.* " & _
"FROM tbl_GCDS_Operations_Positions_Fills_Log " & _
"WHERE (((tbl_GCDS_Operations_Positions_Fills_Log.[ID])=' " & Me.cboDate.Column(0, Me.cboDate.ListIndex) & "'))" & _
"ORDER BY tbl_GCDS_Operations_Positions_Fills_Log.[ID];"
Me.Requery
 
Last edited:

Users who are viewing this thread

Top Bottom