If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto fill
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! |
#2
|
|||
|
|||
auto fill
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 "Rog" wrote in message ... 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! |
#3
|
|||
|
|||
auto fill
On Tue, 20 Jun 2006 12:29:02 -0700, Rog
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Turn off Auto Fill In??? | Doug in Texas | Running & Setting Up Queries | 3 | June 19th, 2006 04:11 AM |
Auto fill option | Thana | New Users | 2 | March 9th, 2006 06:13 PM |
Auto Fill In | Tom | New Users | 3 | August 30th, 2005 05:01 PM |
Auto lookup fill in function - Need more help | Lam | General Discussion | 1 | August 13th, 2004 11:42 PM |
Auto fill criteria/questions on filling formulas down | JAnderson | General Discussion | 2 | July 19th, 2004 09:45 PM |