Autofill

[Woany]

Hi Everyone.

This is the first time I have used Access and I feel I am doing ok - however
I am stuck with one problem. My Database is simple - A table and form for
Products and the same for Clients. The Third form is for Order Entry and I
have inserted a SubReport for the Order Details. I just want to be able
insert my Product Name from a Combo Box, and when the Product is chosen - the
Product Size, Unit Price and Commission Rate to Automatically fill in for
that particular Product. After that the Quantity can be entered manually and
everything else is calculated and I am done. I am new to codes and have tried
the ME. command but it doesn't recognise it. I cannot believe with all of the
complexities of Access that this is not a standard feature. Please help - I
need it for End of Year Presentation on Friday. Thank you in advance

 

[Rick B]

While you can certainly do this, Access already provides you with at least
one database out there that will do almost everything you ask. If you have
not spent too much time on this, I'd recommend you stop and open the
Northwind database that ships with Access and modify it to meet your needs.
I built a Mary Kay Cosmetic database for my wife and used Northwind as my
starting point. You would not even recognize it at this point, but a lot of
the underlying structure is similar and much of the coding related to orders
was done for me.

 

[Woany]

By the Way - All of the Criteria - Product Name, Unit Price, Producr Size and
Commission Rat are in the same table