Thanks in advance to all people seeing this!
I am a newbie in Access and i want to know if it's possible to program my Forms and Subforms so they could read all data from a input Excel file.
Right now, I have succesfully managed to let the user introduce a file(Only Excel files) and grab all the information and put it into a new Access Table. It's important to say that I stored in a separated Module, the information related to each file.( It's Filename and Path).
My issue is that all my current Forms and SubForms are related from an Excel file that I used at the beginning to see working my program. However, I need to set the Source Object Property for each of my Forms and SubForms based on the new file introduced.
Thanks