By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

how to filter a subform from a form

P: 27
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.
Apr 19 '18 #1

✓ answered by 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.

Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,204
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!
Apr 19 '18 #2

P: 27
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

Expand|Select|Wrap|Line Numbers
  1. Me!subfrm_GCDS_Operations_Positions_Fills_Log_New1.Form.RecordSource = "SELECT tbl_GCDS_Operations_Positions_Fills_Log.* " & _
  2. "FROM tbl_GCDS_Operations_Positions_Fills_Log " & _
  3. "WHERE (((tbl_GCDS_Operations_Positions_Fills_Log.[ID])=' " & Me.cboDate.Column(0, Me.cboDate.ListIndex) & "'))" & _
  4. "ORDER BY tbl_GCDS_Operations_Positions_Fills_Log.[ID];"
  5. Me.Requery
  6.  
Apr 19 '18 #3

NeoPa
Expert Mod 15k+
P: 31,409
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.
Apr 20 '18 #4

Post your reply

Sign in to post your reply or Sign up for a free account.