auto fill

[Guest]

I need to be able to enter a drawing number and have the description and
other data auto fill. It seems that everyone wants me to use a combobox but
there are hundreds of drawings so I don't want a drop down list to choose
from. I want to enter the number, move to the nex field and have all the
fields with data filled in automatically. I have the table called MASTER DWG
LIST already set up. Thanks for the help!

 

[Jeff Boyce]

If one person tells me something, that's their opinion. If two people tell
me the same thing, I might consider it. If "everyone" tells me the same
thing, maybe there's something to what they're saying.

I haven't seen your earlier posts, so I have no idea what you're talking
about.

A combo box can be set up to auto-complete, so folks wouldn't have to scroll
through your "hundreds of drawings" to find the one they wanted. They could
just start typing (the IDnumber, the Title, whatever would be easier for
them) and Access will jump to the first listed item that starts that way.

If you describe WHY you want data to autofillin, it could make a difference
in the suggestions you get.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

I need to be able to enter a drawing number and have the description and
other data auto fill. It seems that everyone wants me to use a combobox but
there are hundreds of drawings so I don't want a drop down list to choose
from. I want to enter the number, move to the nex field and have all the
fields with data filled in automatically. I have the table called MASTER DWG
LIST already set up. Thanks for the help!

Are you trying to store the description and the other data
redundantly, copying it from the MASTER DWG LIST into some other
table? If so... DON'T!!! It not only wastes space, it really risks the
quality of your data: if you have to correct the description of a
drawing, you should be able to correct it only once, in the master
table, and then link to it using queries.

Secondly, are you assuming that the only way to use a combo box is to
scroll down the list and select it with the mouse? It's not. You can
tab into a combo and start typing the value; the combo will jump to
the first matching value.

You can (with some VBA code) do what you ask, and if you post back and
explain why, and what's the recordsource of this form, I'll be glad to
post some sample code.

John W. Vinson[MVP]