want text box in form to automatically access info related in list box

[patrickmcdiver]

I am creating a form and have a list box with customer names. That info is drawn from a table with customer info (ie...name, street address, city, state, zip). I want to create text boxes below the list box so that when I pick a customer from the list box, the address info automatically fills in.

Note: The name, street address, city, state, and zip are all separate fields in the table.



Thank you

[RuralGuy]

Use the AfterUpdate event and the Column() property of the ListBox to fill in your TextBoxes.

[patrickmcdiver]

I was going through a tutorial and saw that but upon further inspection of my "event" tab, I don't have an afterUpdate

[patrickmcdiver]

Working in a report not a form is why, I guess

[RuralGuy]

Reports are just a piece of paper and not interactive and a ListBox is not a very good control for a Report.

[patrickmcdiver]

Understood. I haven't worked with databases in over 7 years and even then I was a novice. I am trying to create some pre formatted forms or reports that we use daily here at my dive company. I would like to be able to just plug in the specifics and have it print the report

[RuralGuy]

I appreciate what you are trying to achieve. How can we help?

[patrickmcdiver]

Maybe it would be best to explain my predicament. My Bid Invoice will incorporate many aspects of access but I am conquering them one at a time.

First: I have a table with all of our customers info. My first task on my report is to be able to select one customer from a list or combo and then have the other info such as street address, city, state, and zip fill in automatically from my selection. I have no idea where to begin. Feel free to treat this as if I was 5 yo. LOL. I will not be offended and want to learn

[RuralGuy]

Have you looked at any of the templates that come with Access or the other ones on line?

[patrickmcdiver]

That's what I'm trying now. I may be on to something. I'll keep ya posted

[patrickmcdiver]

no luck. about to give up

[RuralGuy]

I'm sure there is something like Contacts or something like that. That would give you the basic table and you could modify the forms and reports to do what you want. It is by far the best way to go when you have a lot to learn about Access.