True = filter, find, and calculate ?? !!

[Salochin]

Hi All

Sorry but im totally struggling with what is probebly simple to most of you.

right Basics, mutiple tables, done most equations in qry and have all frms designed

this is what I want to acheive...

when an [Item] True / False box is "True"

[price] = [Number] * [PriceperItem]

simple I know but the [PriceperItem] is in another table that has all other items in it also. I belive I need to get vb to find the item and then count to the right coloumn to find the correct [PricePerItem] to work its calculations out if that made sense ?

What Im unsure how to do:

How do I write it as in to get vb to locate another tbl coloumn and filter it at the same time to show results in the form.. do I need to declare veribles for it etc...

*bangs head against desk* please help I am new at this so be paciant with me..

Thanks as always

Sal

[debasisdas]

how both the tables are linked ?

[Salochin]

ah there not (totally new as I say)

I think I will atach db so you can look any constructive comments would be very usefull (but dont do it for me) if that is ok ??