i need a beginner's tutorial for combo boxes

[lois chipperfie]

I need someone(s) to help me build a combo box from scratch. I want to select a name from a combo box, have it find the address in a table, and insert it into a text box below the combo box. The table is not linked to another table. I then want that address to be the beginning of an invoice form that I can add items & prices.

 

[Hayley Baxter]

Why don't you just use the wizard to create your combo box and select option 3 find record on my form which will then display the results of your chosen record on the form?

You can find a beginners guide to access here

http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/mainTOC.pdf
HTH
Hay

 

[lois chipperfie]

o.k. I did that and the correct field data shows up but when I go back to the table only the 1st field (the one in the combo box) is there--not the address data. Now what?

 

[Hayley Baxter]

Not sure I am quite following what you are attempting to achieve, however this is what I think you're trying to do correct me If I am wrong.

You will select your name from the combo box and populate the address detail on the form. You then want to take the address of the selected record to another form so that the address is displayed at the top of this form (this will be your invoice form) is this correct? If so you could link the id chosen in the combo box to match that of the id on the 2nd form.

Let me know if you need more help or If I am completely off track.

Hay

 

[sambo]

Go into the After Update Event of the ComboBox (in the properties menu) and type the following:

Me.Requery

This links the rest of the form to the current value of your combox (if the combo box is set up correctly)

The record source for the from should be a query that selects all values associated w/ the form WHERE (criteria):

Forms!myForm!myComboBoxValue

Create the previous statement by right clicking in the criteria box under your combo box field in the query and choosing build. Self explanatory from there.

 

[lois chipperfie]

Hay-- What you said I'm trying to do is correct.
Now how do I get the address to show up in the 1st table so that I can use it in the invoice?
Sambo--the Me.Requery gave an error message when I keyed it in the AfterUpdateEvent.

 

[sambo]

Chip-
I've been using Access now for just about 3 weeks. I started with absolutely no knowledge of Access or its capabilities. (What a long 3 weeks it has been.)
The first thing I did with Access was to build a single Form that gets its data from a Combo Box. I found a great link for beginners that tells you how to do just this. It doesn't use any wizards, so you actually know what you are doing when you finish.

Try this:
http://www.ageesw.com/access.htm

It should tell you how to build a very simple combo box, much like the one you are building. I built my first one from this example.

 

[lois chipperfie]

Sambo--that site was the one I needed. I was able to get it to work and now know that I can get my application to work!! I think many of the suggestions given me were correct. However, I didn't know exactly where to put them!!! Thank YOU!!!!

 

[sambo]

Some more suggestions from a relatively new person to combo boxes.

Make sure you know what the Column Count and Column Widths properties do. These can control which fields of the query are displayed and how they are displayed (what length they are alotted) If these properties are wrong, then your box won't display anything.

Good Luck