Combo box....???

[bbqxlilprince]

hi, im new to access and im doing my coursework and i am having problems with it...can ne1 tell me if it's possible to create a combo box and when the user selects one of the values, a report of that value will pop up?...if it's possible can u tell me how??...plzzz......!! ty~

 

[ColinEssex]

when the user selects one of the values, a report of that value will pop up?.

I think this needs more explanation, thats why you haven't had a result yet

Col

 

[bbqxlilprince]

well, i meant...when the user clicks one of the value in the list/combo box....a report of that report that value will apear...or pop up....the value in the combo box is based on one of the fields in a table.......im sorry if u don't understand.....im not good at explaining things....

 

[ColinEssex]

I think its the word "report" thats causing the confusion.

Are you meaning that if you select a value in the ComboBox you want the full description to appear in a field next to it for example?

I appreciate its often difficult to explain exactly what you mean. You could try posting your Db or a screenShot of the form.

Col

 

[bbqxlilprince]

well....not really....i want a combo box to act like a button taht links to the report...so ....for a button ...when the user clicks on the button...a report willl open....but for combo box...when the user selects a value in the combo box....a report will open...but of that value.....

I can't upload it yet...cos im in schoola t the mo and the file is at home...please wait/.....

 

[Hayley Baxter]

I posted a sample in this thread if this helps you any, only the report opens upon first selecting a value in your combo box then clicking a cmdbutton to open the report with that value. This will still do what you're asking for but if you don't want the cmdbutton and just want to open the report upon click of your value you'll need to change it slightly.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33252

Hay

 

[bbqxlilprince]

THANK YOU....That's what i want....but....how do i do it?

 

[Hayley Baxter]

You'll need to create a query and have this look to the combo box on your form for a value. If you look at the sample I posted you'll see under ContractTypeID:

under criteria

[Forms]![ContractTypeDialoug]![Combo9] where contracttypedialoug is the name of the form and combo9 is the combo on that form

If you need a hand you can post your db.

 

[bbqxlilprince]

ty....here's the file:
http://www.geocities.com/becky_choi01/On9class001.zip

 

[Hayley Baxter]

That link is not working, can you try again and I'll have a look for you.

 

[realnine]

bbqxlilprince,
Tyr this:
In design view, go to the properties of the combo list and select the event tab. In the after update line select event to bulit code to open your report or select macro and build a macro to run your report. If you choose the macro approach, you have to build the macro first before changing the properties settings. The macro will then show on your pulldown on the after event row.

HTH

So much to know, so little time,
Old Real

 

[bbqxlilprince]

o...then try this one:
www34.brinkster.com/bbq12/On9class001.zip

 

[Hayley Baxter]

hmmm no that's not working either I'm afraid. Is it too big to attach to the forum? If so you can email it to me at either of the addresses below:

HayleyBaxter716@hotmail.com
HaylBaxter@aol.com

 

[Hayley Baxter]

Ok got it. You'll need to help me here now. Do you already have a form in place for this. I'm guessing here but is it the one form called report I'm looking at? On click of the command button you want to open the report called "All" so that it only displays the value in the drop down as opposed to everything.

Did I get that right?