1. To move the form to someone else's computer you will have to set up the DSN on their machine. You can do this from the Control Panel/ Administrative Tools/ Data Sources ODBC. Each machine will have to have the 32 bit driver that you used as well.Those screens that you used to set up the DSN in Designer are actually Windows screens and you will access them from the location mentioned above. The drivers that you used tend to be loaded by the program mentioned (MicroSoft Access) or you may be able to find it on teh MS site ....those 32bit ODBC drivers may not be there by default.
2. The DDList population can be done after you set up a Data Connection. On the DDList object you need to activate the Dynamic Properties of the object. This is done by clicking on the upper right corner of the Object palette (see image below)
This will open a menu and you need to choose "Show Dynamic Properties"
Any property that is dynamic will show up with a different color and underlined (like a hyperlink - see the image above). Now when you click on that link a wizard will come up and allow you to bind this property to your defined DataSource - in your case columns in your DB.
3. The above technique will work to populate the DDList but if you want to use that to filter further and get a specific record back to populate the rest of the form you will need to write code. There are a couple of different examples of this floating around. I did a webinar on the topic ...and it covers the simple to the more complex :
Or if you want to go directly to a solution one of my co-workers created a blog on the topic:
This is the basic one:
And this is the more advanced topic ...about getting a specific record:
Hope that helps