Auto populate field in access form

[jacklindsay]

Hello smarter people than me

I am creating a database for college, and have requested some help, but they are unable to help me. ( im obviously too eager)

anyway, im creating a database on computer components and peripherals (i.e networking devices, hard drives etc etc), the previous mentioned devices are in a table called product catagories which in the form, are a drop down. I also have 2 text box fields, 1 is for the product manufacturer, and the other is for the model of the product. I have created a table called products, which includes manufacturer, unit price, and other fields (which are linked to other tables) but these 3 are the main ones I am concerntrating on.

here's what i would like the "Orders" form to do. when I fill in the manufacturer field and the model field ( and they match data in the products table) I want the unit price field, to auto populate, based on the data in the products table. I also would like a quantity field to update a total price field based on what is entered in the quantity.

So if,
manufacturer=netgear
Model=DG834G v2
Category=Networking
Unit price=£49.99
Quantity=3
Total price=£149.97



Thanks if anyone can help me.

I hope you understand what I have written. I have never really understood databases

Jack Lindsay

[bloukopkoggelmander]

Hi there

Right, I have had this problem before and if you follow this link then you will see what I have done :

Unable to autofill form fields


As for the total price you will have to write a calculation. That is not too hard to do in Access, just cannot remember from the top of my head how to do it. Have a search for calculations, you will find loads of info on it.

Hope I could have been of some help.

Thanks

[jacklindsay]

dear bloukopkoggelmander

Is there anyway you can make what you was writting about in your other post that you sent me easier to understand? its been along time since i have touched Access, and can hardly remember anything about it.

Thanks for your help

Jack

[NeoPa]

Try it again Jack.
I've updated the link so more info should be visible to you.
If you still need help then you need to ask the question rather than asking someone to retranslate a whole thread for you.

MODERATOR.