Calculation on form and updating results in table

[Kunuk]

Hi, I’m new to Ms Access but I managed to create a database. I have created a table with the following fields
ANIMALSALESID-AutoNumber
CUSTOMERBUYING THE ANIMAL- LookUp created to link to the field name Customer Name from the Customer table
ANIMALNAME-LookUp created to link to the firld name Animal Name from the Animal table
DATEORDERED- Date/Time
NUMBERANIMALORDERED-Number


UNITPRICE-Look Up to look for the fieldname Unit Price from the Table Animal
TOTALPRICEFORANIMAL-Number

Then I have created an AutoForm name as FRMSALES from this table. I have put the TOTALPRICEFORANIMAL in the form Footer.

My questions are:

1. On the form Sales how can I make the Unit Price appear automatically when the Animal name is selected from the list?
2. On the form Sales, how can I calculate the Unit Price being displayed automatically * the NumberofAnimalOrdered field (number which is entered in the textbox must be multiplied by the unit price of the animal)
3. When the totalPrice is calculated, how can Access writes and updates the same answer in the Sales table, particularly in the TotalsSales column?

I have explained it in detail as I am unable to upload the file. Please help and give suggestions.
Thanking you all in anticipation.
\God bless

[Evilferret]

There's probably better way to do this, but...

1 - Add an After Update event to the list. Have the After Update event query the table based upon the Animal Name you selected, and return the appropriate UnitPrice. Set the value of the UnitPrice box equal to the result of the query.

2 - Modify your After Update event on the list to have it do this. Essentially the same thing as in 1, only your query will be NumberofAnimalOrdered * UnitPrice.

3 - Create a button with an OnClick event that retrieves the value from each textbox in VBA code, then writes those values into the Sales table using a SQL statement.

[RuralGuy]

Since you are new to MS Access you should read this: http://access.mvps.org/access/lookupfields.htm