I have a form open in datasheet view. I would like to filter one the fields using a combo box. I am trying to do this using a macro. I can get this to work by typing what I want to filter, but I need to use a combo box. Any suggestions?

Thanks

I am not entirely sure that I understand your situation but I will hopefully provide you with enough info so you can work out your problem.

I currently run reports on project funds that employees receive from large companies. Sometimes a report is run while some of these funds have not been secured.

When I run my report, I want to pick the employees name from a combobox and only select (filter) records that meet the criteria of being funded.

I have a query that includes the ProjectID, Employee Name, Funding Amount, and Status of Funding.
In the Criteria field of the Employee Name column, I have [Forms]![IndividualFundingReport]![Employee Name] which accepts the selected employee name from the combo box which is on my IndividualFundingReport Form.

In the criteria field of Status of Funding, I have "funded" to selectively filter out only the records that are tagged as funded.

I hope something here is of help

Thanks for the response. I figured it out a couple days ago.