473,385 Members | 1,333 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Form help

Hi,

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!

Ally
Nov 22 '06 #1
5 1195
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!

Thanks
Nov 22 '06 #2
NeoPa
32,556 Expert Mod 16PB
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
Ok, as I said I know nothing about code so please can you tell me what the code should be?
Nov 23 '06 #4
NeoPa
32,556 Expert Mod 16PB
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
Thanks what a helpful forum this is.
Nov 23 '06 #6

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

Similar topics

1
by: Randell D. | last post by:
HELP! I am determined to stick with this... I'm getting there... for those who haven't read my earlier posts, I'm createing what should be a simple function that I can call to check that...
4
by: Tonya | last post by:
Hi, Does anyone have any example of how i can manage forms in my application?? I want to be able to reference my form instances that are currently open from other forms. why cant i open...
10
by: Gregory A Greenman | last post by:
I'm trying to write a program in vb.net to automate filling out a series of forms on a website. There are three forms I need to fill out in sequence. The first one is urlencoded. My program is...
0
by: Pat Patterson | last post by:
I'm having serious issues with a page I'm developing. I just need some simple help, and was hoping someone might be able to help me out in here. I have a form, that consists of 3 pages of...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
4
by: Dave Guenthner | last post by:
I have a csharp form1.cs created with VS. I have added a menu bar with one option called help. I then created another form in VS called help.cs. How can I launch the help form from the main form...
10
by: Kathy Burke | last post by:
HI. in asp.net app, I have an xmlDocument that I transform to the client html. Using xsl I create a few textboxes to capture user input. Each of these are related to <data> elements in the xmlDoc....
13
by: Lee Newson | last post by:
Hi, I have just written my first application using VB.NET. The app works fine when i am running it within .NET for debugging purposes, however when i try to run the app from the .exe file that...
9
by: mohit.akl | last post by:
Hey guys & gals I am havng trouble modifying the control box. I want to make the maximise button invisible and have minimisise button instead of it. Like this _ X (not like _ o X ) How...
9
by: MikeB | last post by:
Hi, I'd appreciate some help, please. I'm writing a VS2005 VB project for school and one of the requirements is that every screen should have a "Help" button. I could do it by writing a clumsy...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.