Access 97 Multiple Filtering Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I just have a question, I have a subform in another form, and what i want is
that whenever i click on one of the fields inside that subform, it will open
up another form that will filter data based on the date and the employee
number that is also in that subform...

For example, in the subform, I have date, and employee id, when i click on
either of the fields, a form will pop up with the same data, but this time, i
can edit those data.

Thank you very much!

Arj
 
Try an OnClick event procedure that looks something like this:

DoCmd.OpenForm "MyForm",,,"[WorkDate] = #" & Me![WorkDate] & "# AND
[EmployeeID] = " & Me![EmployeeID]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with a query 1
Access Daily Entry with multiple entries per field 0
Parameter Value error in a Subform 0
Subform Data Entry Setting 0
Subform Multiple Entries 1
Updating tables when you input new data 0
Problem with form--subform 5
Access 2007 - Filtering information in a form? 3

Back
Top