self populating form

[Sunstar]

Hi everyone. I'm new to database design and hoping htis is a simple question.

I have nine thousand products each with their own code and description. I want a form that allows me to enter a product code and will then self populate an adjoining box with the corresponding description. I would like to enter at least fifteen codes per form.

I tried a linked form and sub form with a child/parent link but the tables info can be changed if the form user edits/deletes etc a code.

I tried a parameter query but don't know how to do more than one and the format isn't really suitable.

Any suggestions would be very much appreciated.
Thanks
Sunstar

 

[wazz]

do you mean you want 15 user-entry-boxes and 15 description-boxes on one form? what will happen next?

 

[workmad3]

right. this is really a job for some VBA code.

What you basically want is to put some code in the AfterUpdate event of each text box, which finds the description for the entered code, and populates the description text box with the info.

Its not very difficult, hope this gives you enough of a pointer to get it working

 

[Sunstar]

Was hoping for an easy solution but sorta suspected I would need some code. Hows your coding workmad3? I have yet to delve into the mysteries of VB.
Or am I going about this in the wrong way? Looking at a later posting
"Help with populating data in forms. " from justdaflava - would that work for me?
Hoping to hear back from some coding genius, even a mediocre coder would be a huge help to me.
Thanks in advance from Sunstar