Getting Field value from Current form

J

Jason Frazer

I have a current form called "MSDS Tab Query" the control souce is a query named "Tab Query
Tab query compiles data from 2 tables "product" and "MSDS
I need to get the value of field Productname from the current record in the query "MSDS Tab Query" in the currently loaded form and set that equal to "strproductname"
how can i do this

Thanks for any input
Jason
 
Top