Unanswered: URGENT!!!How to filter more than 3 criteria to get specific record??
I have 2 forms ( frmTask & DiaryPlannerfrm)which have bounded table( Task Folders & DiaryPlannertbl)
Primary key for Task Folders is TaskID
In form DiaryPlannerfrm I have textboxes for time which have properties name as follow0700,0730,0800,0830,0900
In this form,there are textbox for name[Text89] but the table bound to this field name is Emp Name.
There are also Subform where there is an ActiveX called ActiveXCtl343.
In form frmTask, there are many fields.All we need is 3 field in this form in order to get specific record,for read-only.
They are Due Date,Time Start & Surveyor
User will select a date from ActiveXCtl343 in subform and also a drop down list [Text89] to select name.
Then the user will dblclick on textbox on specific time that they want E.g: 0700
When dblclick I want it to run the filter and find the specific record in Task Folders(tbl for frmTask)if they found the SPECIFIC record then open frmTask to show the record. If not then "record not found".
Basically, if Due Date = ActiveXCtl343 and
if Time Start = 0700 and
if Surveyor = Text89 then OPEN frmTask
If there is any more question feel free to ask.
This is really urgent, near to getting kick in the ass!!
Please help if can , anybody!!