Hey Guys

I've got a form (Form1) in access with 3 fields:

user text entry of a number called intFormula
user selected drop down box called CurrentDrop
user selected drop down box called Proposed Drop.

The idea is Form1 opens F:Exchanges showing only data corresponding to CurrentDrop and Proposed Drop, then does calculations based on data in a table using the inFormula expression.
An automatic command button has been created which opens all the records compared to CurrentDrop, and the ProposedDrop and intformula are to be passed across to used in other code which i know works i just can't pass the fields over.

Can someone give me some pointers, its been a while since i've done any of it!?

Please and thank you!
K+ For the correct working answer! hehe!