Filter a continuous form
Private Sub cmdApplyDateFilter_Click()
Me.Filter = Me.ScheduledStartDate = " Between #" & Me.txtStartDate & "# and #" & Me.txtEndDate & "# "
Me.FilterOn = True
It 'appears' to work but returns no records when I enter a date in each of the ext boxes. The dates are in a valid date format similar to 0810/2011 and 08/31/2011
I know for a fact that there are records that fall into this date range
Thank you for taking the time to report an issue.
What's wrong... Please write below.
There are four unbound combo-boxes in the header that the user can choose from and then I have a command button coded to filter (Me.FilterOn) for those criteria.
The matching records display in the details section of the form (continuous-style).
Is there a command to reset the details section of the form to be blank? Ive tried refresh, requery, repaint, etc. All of these leave the previously queried data. Removing the filter doesnt work because that display all the records. I basically want the form to look exactly the way it did when it was first opened.
Serial #, Part #, Model #
I want to put combo boxes in the header to filter the form. I have a combo box for each field. I named them:
SerialSearch, PartSearch, ModelSearch
The combo boxes are based on tables to automatically update when a new serial, part, model # is added. So, I got this far, so now I have a continuous form with three combo boxes in the header. I can select a value from the combo boxes, but I have no idea how get these to filter the records. I would like to be able to enter values into multiple combo boxes and have it filter, or when the combo boxes are blank, I would like it to show all records.
StrContactNo, StrLName, StrFName, StrAddressLine1, StrAddressLine2, StrParish, StrMale, StrFemale
The form is continuous and is a pop up form.
I would like to filter the data by Last Name on the form so as to the view a particular person rather than having to scroll down the list.
I tried the filter option which on Northwind database and cant seem to get it to work, I tried this link . not working, and several others on the internet cant seem to get the filter to work
The problem is with generating the graph. I'd like to use the form's filter for bounding the graph's data. So records shown in Form1 must be used for the new graph (Graph1 in Form2). Isthere a way to copy the filter to the new form or use the data?
I know that this is explained quite weirdly, but I cannot think of another way at this moment.
Private Sub Option25_Click()
Me.Filter = " "
Me.FilterOn = True
How can I get the screen position of a control for the current record in a continuous form?
(frmStudents is linked with the combo box in the frmMain)
But now I want my sub form (frmStudents) as a Continuous form but it does not allow me because it also contains a sub form.
When the second form opens only the matching records are shown. The second form also has a command button used to sort the records.
by using the following code from the main form and it works fine.
Private Sub Form_Current()
strWhere = "[Seder_Code]=" & G_Seder & " AND " & "[Bahoor_Code]=" & G_NameCode
Me.SubFormFines.Form.Filter = strWhere
Me.SubFormFines.Form.FilterOn = True
The problem starts when I try to enter details on the continuous subform.
For example when I have filtered 3 records and I want to amend the third record the cursor jumps to the first line.
I've realized that it happens because the subform is still on FilterOn = True
I would like to turn off the filter and to be able to change the details on the subform and still having only the 3 records that have been filtered before.
Where can I switch off the filter and how