I have a question for an access expert please

Microsoft office 2007 and calculations in forms

geek_abbey_magick, Sep 23, 5:47 pm

what's the question?

geek_jayc2007, Sep 23, 6:02 pm

I wish to perform a calculation in a text box on a form.

The 2 things i need to add are items on 2 seperate tables.
1 number from one table, and 3 numbers (in the same column) on another table.

Can it be done?

geek_abbey_magick, Sep 23, 6:14 pm

Also I need to know how to pre populate a box in a form.
Currently, I have a form with a combo box, to select a car to purchase. The second box needs to pre populate with "that" cars price.
Is there a way to do this please?
I have MS Access 2007

geek_abbey_magick, Sep 23, 7:29 pm

You need a Safe-Cracker Access Expert.

geek_deodar1, Sep 23, 8:01 pm

Yes the figures can be calculated and depending on the circumstances there are a few ways to do that.

Bind the combo box to the table with the data you require.

You could pay someone to provide the results you want.

geek_d.laidlaw, Sep 23, 8:05 pm

google "cascading combo boxes"

geek_gibler, Sep 23, 8:17 pm