i have two forms and running access 2007:p
i want a button to go from one form the the other and query the data as it goes.
but
when i have this macro behind the button it goes from the form to the other form and provides a box asking for a value to search for. no matter how hard i try i cant...