auto populating text boxes on a form based on one entry

[RnRExpress]

Not sure if I will be able to explain this without getting all confusing, but here it goes.

I have one table called Loaner_Reg. This table has 4 pieces of data: LNumber; LMake; LModel; LSerial. A typical piece of data would be:

1; Nokia; 5165; 12345678901
2; Motorola; 343; 05000000000

and so on and so forth.

My main data entry form tracks various information, including the loaner number, loaner make, loaner model, and loaner serial. Normally, everything has to be entered manually.

What I am trying to do, without much sucess, is if the data entry person enters a "1" in the Loaner Number" field on this entry form, I would like the form to go and grab the data from the Loaner_Reg table, and automatically populate the other fields on the form, such as Loaner Make, Loaner Model, and Loaner Serial. However, if the data entry person does not enter a number into the Loaner Number text box, then the additional fields are not filled in, and the person needsto enter these things in manually.

I tried playing with a combo box type thing, and select from a drop list, but this lsit would get extremely long, considering I am probably going to have up to 100+ for data records in the "loaner_reg" table.

Any suggestions would be appreciated.

Thanks!!

Richard

 

[Blorf]

Hi. How about some dlookups on your numbers after update event?

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.