Help with drop downs & auto entries for Forms

[USAussie]

Hi everyone! Hoping someone can help me. I'm an intermediate user of Access but I need some help with a database I'm expanding on. Here's the scenario:

I have a customer table and an inventory table. I am creating a form that will allow users to enter customer details when a sale is made, and I want them to be able to select from some kind of a drop down box the item in the inventory that is being purchased without having to type everything (make, model, VIN etc) in manually.
So I want them to be able to click on say the model number or VIN, and once they click on the item that's being purchased all the rest of the details will automatically come up - Year, model, make, VIN etc.

After all of the information for that sale is entered they will then save the data and go to a report to print out the customer's quote or invoice. This saved information will then be used by me to draft all the rest of the paperwork up for the sale.

I've been looking around for something online to help but just having trouble finding something that I can understand.


Hoping someone will be able to help!

 

[pbaldy]

Is this wht you need?

http://www.baldyweb.com/Autofill.htm

 

[USAussie]

Is this wht you need?

Hi Paul,
Thanks for your reply. I did see your autofill post on someone else's question that was similar but it's too hard for me to grasp. I couldn't get what I had to do from your instructions.

 

[pbaldy]

Where are you stuck? I'm not sure how to explain it any clearer.

 

[USAussie]

I don't know where to put the formulas you provided. I also tried following these instructions but all I get is a blank form coming up once the wizard is through. I don't get what I'm doing wrong.
[ehow.com/how_6547684_auto-fill-access.html]

 

[pbaldy]

Which formulas (which method are you trying to use)?

 

[USAussie]

I'm trying to use the version that will allow the data to be saved. I know I sound like a total idiot. I usually don't have any trouble with formulas and I'm sure I've done this before sometime in the past but just can't get my head around it now for some reason.
All I know is I just want to be able to enter in the customer's details then once I get to the unit they are purchasing I just want to be able to select the make or vin and have the rest of the data relating to the unit populate so I don't have to enter it all manually.

 

[pbaldy]

This is how you get to the code editor

http://www.baldyweb.com/FirstVBA.htm

In your case you want the after update event of the combo.

 

[USAussie]

Thanks very much I'll look this over and give it a go and see how I go with it. I really appreciate the help.

 

[pbaldy]

No problem, and welcome to the site by the way.

 

[USAussie]

Thanks. I'm here all the time getting info and tips but I just don't post. It's the best place on the web to figure out access problems.

 

[USAussie]

Ugh ok I am still at square one. I don't understand what I need to put for the Combo.name and what column to select because I don't know what the combo is. I just confused as all hell. Thinking I'm just going to have to give up on the whole idea I just don't get it.
I got as far as entering the event SQL screen but yeah not understanding the code still and yeah.. I mean am I mean to have combo boxes set up with the lookup wizard for each field I want to copy over? I've got no idea....

 

[USAussie]

I just found some more instructions that have helped me a HEAP! I think I've got it finally by golly lol thank god! Thanks so much for the help I think we can consider the case closed.