Populated Form Datasheet from Table Field

[Glenn E. White]

Please help! I have a subform on a main form that I would like to populate the first field with data from another field in another table. What would be to most efficient way to accomplish this

Any and all advice or directions would be greatly appreciated

Sincerely

 

[Jackie]

Glenn
Is there any relationship between the field wanted and the subform? What you are trying to do can be accomplished in a couple of ways depending on the link. You can either have the default value of the field to point to the value desired or you can set the value in code but there needs to be a link or you will not be able to specify which record in the table you need.

 

[news.east.earthlink.net]

Open the subform in design mode and change its record source to a query that
includes the needed field. (The two tables must have a relationship - a
common field in both tables.) now drag the field from the field list onto
your form.

Please help! I have a subform on a main form that I would like to

populate the first field with data from another field in another table.
What would be to most efficient way to accomplish this?