how to filter a subform from a form

[ivonsurf123]

Hello,

I have a question on how can I filter fields from Subform to a form, attached is the database I am working on, also does anybody know the format to use as numeric field in a query, like # for Date? Thank you.

[twinnyfo]

Ivon,

Please refer the the guidelines on Asking Good Questions first.

Second, we are typically not going to open a DB that has been freely posted on the forum. Please tell us exactly what it is that you are having problems with, describe what you have tried already (including the troublesome code you are using) and then we can better troubleshoot your problem.

Thanks!

[ivonsurf123]

I apologize did not know about the zip file.

This is where I need help with: 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
 

[NeoPa]

Quotes (') and Double-Quotes (") - Where and When to use them may help. It also covers numerics - which actually don't even need delimiters.

*Edit.
I just checked and neither article explains how to include numeric literals in a SQL string. Never mind. They need no delimiters at all so it's fairly simple.