automatically populating record values in form text boxes

[stardusty]

Four tables and a junctioning query underlie two forms. The first form is used to enter new records into the tables. The second form would be used to edit values in the tables.

In the second form, upon entering a unique value, such as LastName, in a text box, what would I do to automatically populate the other 14 values from that respective record in the remaining 14 text boxes of the form?

 

[Jack Cowley]

No need to. You already have the data in another table and the object is to reduce redundancy not create it.

 

[stardusty]

Jack, you're a great editor.
My mistake was to say a second 'table' in the outset of the second paragraph. What I have is a second 'form.'

 

[Jack Cowley]

You really do not need a second form to edit your data. You can edit it in your existing form if you like.... To do what you want base the form on your table. Once your form is complete create a combo box on the form using the Wizard. On the first screen of the Wizard select the third item, "Find a record....". Finish the Wizard. Now when you select a name from the combo box the correct record will be displayed ready for editing or whatever.

Good luck.