Hi,
I built an Access DB where a users goes to Form1 and Selects a Department and file from Combo1 and List1 on Form1.
In my Excel to Export Module, it excutes the table export correctly, but does not pass the value from combo1 to my information query. All the data is exporting except the information query. If I pull out the information query parameter, then every works ok.
I have a feeling something needs to change in my export module to capture the value in combo1 in my inforamtion query.
I attached the DB and excel file that the DB export to. In tab two(job code info) is where the information query should populate.
I built an Access DB where a users goes to Form1 and Selects a Department and file from Combo1 and List1 on Form1.
In my Excel to Export Module, it excutes the table export correctly, but does not pass the value from combo1 to my information query. All the data is exporting except the information query. If I pull out the information query parameter, then every works ok.
I have a feeling something needs to change in my export module to capture the value in combo1 in my inforamtion query.
I attached the DB and excel file that the DB export to. In tab two(job code info) is where the information query should populate.