Select from Combo box and "auto-populate" 2

[gse14]

I will preface my post by saying I am very new to access. VBA skills are very limited.

I would like to know the best way to accomplish the following: I want to create a form that has a combobox with all client's last names. Once the user picks the last name, I would like the address fields to autopopulate with the client's address. The information is all in one table (last name, street address, city, state, zip).

I will use this form to feed parameters to an invoice report. This invoice report will not be pulling rates (and generating billing figures) from the database - it is just going to grab the client name and address and be used for a quick way to generate an interim invoice. The database is used solely for generating invoices and billing numbers - however I want the ability to print invoices based on manually entered data. Sort of like filling out an adobe *.pdf form.

I hope this makes sense.
Thanks.

 

[formerTexan]

Expand the SQL strig for the combo box's rowsource to include the necessary address fields. Add the corresponding columns to the combo box (you can set the column width to 0" to keep them invisible to viewers).

Then push the information from the combo box to unbound text boxes on the combo box's AfterUpdate event. Remember that column numbers begin at zero

For example:

Me.txtClientAddress = Me.cboYourComboBox.column(2)

Cheers,
Bill

 

[markswan20]

I've been given this link and i have tried to answer my question but have been unable to, could someone please elaborate on this thread please.

I need to add a combo box on a sheet to display 1 type of information. I have followed a certain amount of the thread but i'm getting stuck.

Here is what i have done already could someone tell me if i'm heading in the right direction.

I have created a combo box, the wizard has popped up and i have selected to enter the information manually. I have selected 2 columns the first for the part i am looking to sell and the second is used for the price. I have changed the column width for the second column to 0cm which has hidden it from jo public. Now this is where i have become a little stuck what do i have to do from here?

My combo box is called Products1 and the box i am looking at using for the price is called prices.

I would be gratefull if someone could explain in very easy laymans terms how to finish my problem or point me in the correct direction if i have gone wrong.

Very Kind Regards
Mark

 

[PHV]

Doesn't are the parts and prices stored in a table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[markswan20]

Not yet but i can put them in the table