Variable Autofill

[Jchristensen]

Good Morning,

I have a simple question, that might have a simple answer yet i do not have any knowledge of it.

My problem is this, I have a form that has multiple text boxes. One of the text boxes is a "project number". Some of the other fields are town, state, and another field called a wirecenter that identifys a town area.

Project numbers all have there own fields above.

EX:

Project Number: JCX108AC
State: MA
Town: Lawrence
Wire Center: 1234

Now, i thought i could have if else statements saying if they inputted "JXC108AC" then it puts in these details into the fields. I want to do this to reduce the amount of typing and reduce the probability of mistyping or user input error.

I have multiple project numbers (around 40) so if anyone could help me to an easy solution please let me know.

PS: it cant just pull the information, it has to store it also.. so no Dlookups and such.

So, input project number > retrieve data / autofill > store data along with job number

Thanks for the review of my problem!

Sincerly,
Jon

 

[namliam]

Create a subform for your aditional data to be displayed and connect that using your project number.

I cannot imagine writing if's for all project numbers you know, it is better to store them in a table and if need be use DLookups but preferably a subform (I think) to retrieve the data.

 

[RuralGuy]

It sounds to me like a situation where a ComboBox would work best. Mastering the Combo Box NotInList Event

 

[Jchristensen]

well, i dont want them to select something since they would have to scroll through a significant amount of data when they can easily type out a 8 combination of numbers and letters.

Anyone have a better solution?

 

[RuralGuy]

Have you seen this? Combos with Tens of Thousands of Records

 

[namliam]

Combos also allow for text to be typed and whats wrong with a text box and subform combination?

 

[Jchristensen]

i tried the text box with the subform combination, and this is my results.

I have a main form, with the project number text box for what the user would input the project number.

Now, the subform has the project number as linked fields. There are two other text boxes on the subform that pull the right information obviously.

My only problem is now, how do i get the information (the last two fields on the subform) back on the main form for storage?

 

[namliam]

Why do you want to store information in this form/table that is allready available someplace else...

Did you look into normalization and stuff like that?