By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Filtering Subforms

P: 7

I have 3 tables: User, Customer and Customer order.

I have a query that picks up all the orders captured for a given User.

Each of the orders have a capture date.

My main form is based on the Users table.

My sub form is based on the Orders table (and is viewed in datasheet mode, using my query). If I scroll through the records on the main form, i.e. users, the sub form list all the orders captured by the given user. I want to be able to filter the sub form further, by date, based on a value held in a unbound combo box which shows the date.

I have tried all sorts of code but to no avail, how can I filter the results of my sub form based on a value held in an unbound field in the main form ?

Also, if I was to change this value, how would I requery the results ?

Your help will be greatly appreciated.
Oct 9 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.