Search results

I have an A2007 database with a table called ComplaintsData which contains two date fields [Complaint Received] and [Complaint Closed] I have a little search form called "ParamForm" which has two unbound text boxes "StartDate" and "EndDate" which, when used in conjunction with queries allows...

AAARRRGGGHHH!!!!!! I can't believe it was something so simple. No I understand why I kept getting error messages telling me ComplaintID was undefined. Many thanks, it was driving me crazy. T

I have done, and I've removed all extraneous code from it. T

I now have: Option Compare Database Private Sub ComplaintID_Click() DoCmd.OpenForm "Complaints", , , "[ComplaintiD] = '" & Me.ComplaintID & "'" End Sub Private Sub Form_Current() If Me.Dirty Then Me.Dirty = False End Sub In the Subform where "Complaints" is the form I want to load and...

Thanks. Should I add the on double click to the search form or the sub form? Also, what is the "IF me.Dirty" command and where should it be added? T

I have a fairly simple Access 2007 database. It consists of a form, called "Complaints" which, as the name suggests, is used to record customer complaints. These are saved into a table called "ComplaintData". I have another form called "Search" which has a subform called "SearchComplaintData"...