Combo Box & Query??

[Jadey]

Is it possible to calculate two fields from the SAME combo box and one from outside it? and how do i place the result in a text box if it is possible?

The form itself is based on a query that has ALL tables and fields from my DB, (it's a small db)

I haven't used access since 1998, I have no idea what I'm doing with 2007 version ={

Thanks for any help,
Jadey xx

 

[KathyL]

Generally you don’t do calculations within a combo box. It sounds like you should have a subform of related records.

But calculations for a field can include fields from either the subform or the main form.

Big challenge for you.. perhaps take a college class.