Assuming you're storing the default values of your "object" in a table, then just open a recordset after the main object
is filled, then fill your other textboxes:

Dim rst As ADODB.Recordset

Set rst = new ADODB.Recordset
rst.OPen "SELECT * FROM SomeTable WHERE SomeObjectID=" & TheSelectedObjectID, CurrentProject.Connection

If Not (rst.EOF and rst.BOF) Then
 '/now fill your textboxes
 With Forms("YourOtherForm")
   .Textbox1 = rst("Field1")
   .Textbox2= rst("Field2")
   .Textbox3= rst("Field3")
 End With
End IF

Set rst = Nothing

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Two points:

1. You're not storing data in a Form. The form is JUST A WINDOW; the data is
stored in your Table, not in the textboxes.

2. If you're extracting these three fields from one table and storing them
redundantly in another table, you are probably making a big mistake.
Relational databases use the "Grandmother's Pantry Principle": "a place - ONE
place! - for everything, everything in its place". You may just want to store
a foreign key, a link to the object table to *display* the characteristics.
It's convenient to use a Combo Box to select from the list of objects; you can
include the other three fields in the combo's Row Source query and display
them on the form using textboxes with control sources like

=comboboxname.Column(n)

where n is the zero based index of the field you want displayed.

If you have a good reason to store the data redundantly please explain - it
can be done, it's just that "best practices" would usually prohibit doing so.

            John W. Vinson [MVP]