Based on the users I will have, I will need something that is as user-friendly as possible, thus, having them fill in the fields will be my unfortunate answer. I already have a form set up where they will enter the fields they so choose. Right below these entry boxes is a tabular query subform that I want to show them the results of their "search".
Your idea to test for filled fields and then filter the subform myself makes...
Leah Trahan
Last Activity: Jan 22 '07, 03:39 PM
Joined: Jan 17 '07
Location: Texas
-
Steve, I am not good enough at this yet to be able to apply your answer. Maybe if I could give a little more info (Note: initial question should be corrected to 6 field to search for and 2 just for viewing)
The user will enter values in the following controls (located all on the same form) in different combinations (depending on what they are searching for) (and some of them being left null): (1) a date range (txtDate1) & (txtDate2),...Leave a comment:
-
Query that will search for mulitiple criteria in mulitiple combinations
I've got a query that returns 8 fields, 7 of which I need to search for in various combinations and the other 1 (Cost) just to view its contents. Below is the mess I've made of it so far:
SELECT tblNCRRpt.dtmNC RDate, tblNCRRpt.idsNC RNum, tblNCRRpt.chrVe ndr, tblNCRRpt.chrPa rtNam, tblNCRRpt.chrPa rtNum, tblNCRRpt.chrSe rNum, tblNCRRpt.chrDi sp, tblNCRRpt.curCo st
FROM tblNCRRpt
WHERE (((tblNCRRpt.id sNCRNum) Like [Forms]![frmSrchNCR]![txtNCRNum]))... -
Thanks for your replies, but I figured it out in the meantime! All I had to do was to use the cmd button wizard! Geez! I had created the button, originally, thinking I would have to use some specially created macro, so I had skipped the wizard... It created the following event procedure:
...Code:Private Sub cmdView_Click() On Error GoTo Err_cmdView_Click Dim stDocName As String Dim stLinkCriteria AsLeave a comment:
-
Open form that shows current record
I am new at Access, databases, AND posting threads (sorry). I have a subform that is a continuous form based on a tabular query. I enter a particular serial # (on the main form) and the subform shows me one to several forms that are related to that serial #. Each form shows only a few select fields of that particular record. I would like to be able to click a Veiw button (which is a cmd button on this subform) to bring up yet another form that...
No activity results to display
Leave a comment: