I am trying to retrieve multiple fields from a SQL table such as customer name, address and phone number by entering the customer # in my form either in a text field or a data drop down list. I can get the drop downlist to populate from the table, however the other fields do not coorespond to my selection. It appears that they are from the first record in the table regardless of which customer # I select from the drop down list. Any assistance would be greatly appreciated.
Take a look at Stefan Cameron's site - http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/
Lots of good information for connecting forms to data sources and walking the results.
Tried to follow Marks link but didn’t work.
Try this one.
At the moment I am about to start on this process with my form, so if you have any tips , please pass them on.
Thank you so much! I am looking at it now.
First Transit, Inc.
NETSPAP Project Manager
799 Roosevelt Road
Building 4, Suite 200
Glen Ellyn, IL 60137