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

Form help

P: 17

Sorry to be a numpty! I'm pretty new to Access and there are a lot of things I haven't figured out yet.
I'm using Access 97. I don't know anything about code or VB!
Basically, I want a form where I'm able to select a particular date or location etc from combo boxes, and for it to show me the corresponding revenue and profit from a query eg. 3/11/06 revenue:300 profit:100, 3/11/06 Madeira revenue:120 profit 40.
Any ideas how to do this? How do I get the combo boxes to relate to each other eg. if you select a date, it only shows the locations visited on that date?
In the query I have this expression which I copied from another form but I'm not sure what it does:
Like IIf([Forms]![Report Form]![Date] Is Not Null,[Forms]![Report Form]![Date],"*")

Thanks for your help and sorry to be thick!

Nov 22 '06 #1
Share this Question
Share on Google+
5 Replies

P: 17
Sorry I've been trying to figure this out all day. I've got the combo boxes to relate to each other but I can't get the revenue and profit boxes to display the values based on what I select in the combo boxes.
Help please!

Nov 22 '06 #2

Expert Mod 15k+
P: 31,489
Have code which runs in the AfterUpdate event (needs to be in AU event for both controls) which sets the filter for the form.
The form should be based on a query (or the table) which includes all, but the filter ensures only matching records are included.
Nov 22 '06 #3

P: 17
Ok, as I said I know nothing about code so please can you tell me what the code should be?
Nov 23 '06 #4

Expert Mod 15k+
P: 31,489
In view of your comments in the other thread (Combo box refers to a combo box which refers to another combo box????) I will not contribute further to this one.
Nov 23 '06 #5

P: 17
Thanks what a helpful forum this is.
Nov 23 '06 #6

Post your reply

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