Pull data from access form

[thielnicole]

I am completely new to VBA programming. I have a Microsoft access form that has a button that when you click it, it opens an excel worksheet. This worksheet has specific cells that I want populated with data from the previously mentioned access form that was filled out before clicking the button. This form is also linked to tables, reports, queries, and databases. I cannot for the life of me figure out how to get this to happen. Can anyone please help me out here? I assume that it is easier to do the programming in each excel cell. Many thanks!

Nicole

[nathansav]

xl.activesheet.range("a1").value = me.txtAccessField.value