471,354 Members | 1,764 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Auto fill trouble

Jim
I have a new database in which I have a form where in one field I type
a letter A, B, C or D and the field next to it autofills (auto lookups)
with a description associated with the specific letter. If I edit the
description for one record, it edits the same for all records in which
I've applied the same autofill (auto lookup). I'm set up where the
letters come from a lookup combo box (limit to list "Yes") and the
record source for the form is a select query with two tables using a
one-to-many relationship. The relationship goes from the first table's
field where the letter is entered to the second table's field with the
same letters and a second corresponding field with a description for
each letter.

My desire is to autofill (auto lookup) the second field of a record and
to be able to edit (add or delete information) in that record's field
without altering the original description in the "many" table.

Please let me know if there are any solutions to this small but
debilitating problem.

Thanks

Jim

Nov 28 '06 #1
1 2214
Hi Jim

If I understand your question right then a possible solution would be
to handle the two fields as separate entries to your table. So your
underlying table has Field "ABC" and field "Description" in it with
only "ABC" limited to the list!

Make "ABC" a combo box with two columns based on your constraining
table ("A", Description Text") then using the OnClick event on the
combo box populate the "Description" field with the data held in the
second column (Me!Description = Me!ABC.column(1) I think, remember
column numbering starts at 0 not 1!) this should populate the
Description field with the data associated with "A","B","C" etc but
since the data in the "Description" field is not constrained you can do
whatever you wish with the text in it!

Purpleflash

Jim wrote:
I have a new database in which I have a form where in one field I type
a letter A, B, C or D and the field next to it autofills (auto lookups)
with a description associated with the specific letter. If I edit the
description for one record, it edits the same for all records in which
I've applied the same autofill (auto lookup). I'm set up where the
letters come from a lookup combo box (limit to list "Yes") and the
record source for the form is a select query with two tables using a
one-to-many relationship. The relationship goes from the first table's
field where the letter is entered to the second table's field with the
same letters and a second corresponding field with a description for
each letter.

My desire is to autofill (auto lookup) the second field of a record and
to be able to edit (add or delete information) in that record's field
without altering the original description in the "many" table.

Please let me know if there are any solutions to this small but
debilitating problem.

Thanks

Jim
Nov 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Sims | last post: by
1 post views Thread by Maurice Mertens | last post: by
3 posts views Thread by Maurice Mertens | last post: by
1 post views Thread by qwas2123 | last post: by
2 posts views Thread by Elainie | last post: by
reply views Thread by Boki | last post: by
10 posts views Thread by Charles Richmond | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.