R
Richard
Bear with me since I am still relatively new and a beginner in this.
I have one form and 2 tables. The main table allows me to track everything
I enter in through the form. The second table just stores 4 things; ID, Make,
Model, Serial (in that specific order).
In the form, I have a a text box where I enter an ID number, followed by the
Make, Model and Serial number. What I would like to do, after entering that
ID number, to have the form check that second table, and if it does find the
ID numebr there, to auto-populate the next three boxes with the data from the
table. If the ID number doesn't exist, or if I skip over the field, then I
would just go along and manualy enter the data. I do not need nor want the
second table updated from these text boxes.
I'd appreciate any help, in getting me started down this path. Thanks!!
Richard
I have one form and 2 tables. The main table allows me to track everything
I enter in through the form. The second table just stores 4 things; ID, Make,
Model, Serial (in that specific order).
In the form, I have a a text box where I enter an ID number, followed by the
Make, Model and Serial number. What I would like to do, after entering that
ID number, to have the form check that second table, and if it does find the
ID numebr there, to auto-populate the next three boxes with the data from the
table. If the ID number doesn't exist, or if I skip over the field, then I
would just go along and manualy enter the data. I do not need nor want the
second table updated from these text boxes.
I'd appreciate any help, in getting me started down this path. Thanks!!
Richard