Drop-down trouble

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christine - 18 Aug 2004 23:15 GMT

I had a value list for several fields. When I created a
graph the plot points were not correct so I deleted the
value list for those fields. Now all of the data,
instead of remaining the same, changed to totally
different #'s.
Example:

Originally Now Reads
1.25 15
1.25 15
1.25 15
1.35 17
1.35 17
1.95 29
1.95 29

etc...

Basically what can I do to get the numbers back to how
they originally looked?

Thank you,
Christine

Reply to this Message

Duane Hookom - 18 Aug 2004 23:40 GMT

Please review this prior to restoring any lookups in field definitions
http://www.mvps.org/access/lookupfields.htm.

Signature

Duane Hookom
MS Access MVP

> I had a value list for several fields. When I created a
> graph the plot points were not correct so I deleted the
[quoted text clipped - 19 lines]
> Thank you,
> Christine

Reply to this Message

- 19 Aug 2004 01:10 GMT

I reviewed the article. Thanks for the information. Now
that the value list is gone, there is no way for me to
get the fields to display the original values choosen
through in the lookup? Do I now have to manually key the
values back into each field?

>-----Original Message-----
>Please review this prior to restoring any lookups in field definitions
[quoted text clipped - 25 lines]
>
>.

Reply to this Message

Duane Hookom - 19 Aug 2004 05:35 GMT

I would create a lookup table and use forms with combo boxes to display the
related values.

Signature

Duane Hookom
MS Access MVP

> I reviewed the article. Thanks for the information. Now
> that the value list is gone, there is no way for me to
[quoted text clipped - 34 lines]
> >
> >.

Reply to this Message