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

Data Acces Page - textbox displays from dropdown selection

P: 3
Please help!
I'm new to TheScripts ...
I've been stuck on this problem for days and I've lost my mind because of it!

I have created a Data Access Page, using Access 2003, named "pg_3_resource_forecast".
When an item is selected in the dropdown list, I want the textbox to display the result. As of now, it does display the results, but it displays numerous copies of the same result.

Example:

Dropdown Selection = Auditor1
Textbox results = Audit1, Audit1, Audit1, Audit1, Audit2, Audit2, Audit2, Audit2, Audit2, etc ....

The results should only have one of Audit1 and Audit2, etc.

I tried to attach the the database in zip form, but the file was too large.
I could send it to you individually.
Any help is appreciated! Thanks in advance!!!
Oct 11 '07 #1
Share this Question
Share on Google+
3 Replies


P: 6
I haven't done Data Access Pages, but it sounds as if you are getting a non-key field, and so you get the value for each record in the table.

Try editing the source for that field and add the word "distinct" as a criteria.
Oct 11 '07 #2

P: 3
I don't have a criteria field.
Any other suggestions?
Oct 12 '07 #3

P: 3
i'm still lost on this one folks
Oct 15 '07 #4

Post your reply

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