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

Transferring Data between Forms

P: 4
Hello All,

I have a tricky problem. I have two forms in MS Access where the user enters information.

The first form links to a table with only one record where data is entered via text boxes. Lets say the user enters "Red", "Blue", "Green" and "Yellow". No problem here.

Now on the second form, the user needs to select some of the information previously entered on form 1 by means of drop-down combo boxes, where these selections from part of seperate records in another table. Lets say on this form he can enter "Cars" and then make a colour selection for record 1. For record 2, he types "Boats" and then makes another colour selection.

I need to find a way of populating the combobox either with a suitable query linked to the combobox record source, a query in VB coding to add to the combobox or maybe by populating a third table that links to the combobox row source. I've tried all manner of tricks and cannot get the (horizontal) single record data into a (vertical) multiple record format.

Anyone with any ideas? Thanks!!
May 7 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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