Selecting from a drop down box

[peckitt99]

Hi

I have a drop down box that has a list of values. how can i get it so that when i select once of the options in the list it will display the rest of the information about it?

for example the drop down box has a list of book numbers. when you select a number the information about the book regarding, author, ispn, title etc are in a table below?

this is what i am trying to achieve if you can think of a better way of doing this please can you say so as i might be making this harder than it actually is

for each booking there should be a list of hires for that booking
• for each booking, the date the booking was made, start date, end date and customer
details should be shown
• the customer should be able to be selected from a drop down list in alphabetical order of
surname
• for each booking there should be a list of hires for that booking
• for each booking, the date the booking was made, start date, end date and customer
details should be shown
• the customer should be able to be selected from a drop down list in alphabetical order of
surname
• for each hire listed, he needs to be able to
o select the category code from a list – when selecting the category code he should
also be able to see the description, intended gender and size
o enter the quantity to order
o see the quantity available and the daily cost for that category.
o see the total charge per day for that category (quantity multiplied

can anyone help?

Thanks in advance

 

[BarryMK]

How did you set up your combo box? What is its record source and do you have an event firing from it? if you post your code it would help.

You'll find examples of combo boxes here look for one that does what you want then check them out in design view to see how they do it.

http://www.access-programmers.co.uk/forums/showthread.php?t=102496&highlight=combo

 

[peckitt99]

to set up my combo i just used the wizard and selected the user names that i want to display. but looking at what i need to do what i listed above i have no idea how to get it all working or even really where to start - if i sent the database so you could see all of my relationships and what i have so far will that help?

 

[BarryMK]

Sure take out any sensitive data and post it here. Plenty of people will take a look at it.