467,161 Members | 1,023 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

Filtering Subforms


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
  • viewed: 1085

Post your reply

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

Similar topics

reply views Thread by Jack | last post: by
3 posts views Thread by Todd | last post: by
1 post views Thread by crazytegger | last post: by
2 posts views Thread by Katie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.