By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

Column Import from Linked Table to Form

P: 2
Hi there,

I'm pretty new at this.

I had one main form and a bunch of tables. One of these tables is linked to an Excel spreadsheet and contains columns of user IDs and training courses. Each user ID has more than one training course linked to it and each row stores one value of ID and course.

I'd like the Form, which also has manually entered user IDs, to display the training courses that match that ID in a text box. How can I get the data from the excel spreadsheet to "pull into" the form to match up with the corresponding user ID from Access and then print to the form a comma-separated list of the training courses?

Thanks so much!

- SD
Mar 12 '07 #1
Share this Question
Share on Google+
3 Replies

P: 1,646
Hi. Are you doing this in access, vb6 or
Mar 12 '07 #2

P: 2
I am using Access. And hoping to program it using VB in the event builder.
Mar 12 '07 #3

P: 1,646
Moving you to the access forum
Mar 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.