What's the quickest and easiest way

[bistec]

I have an main form with subform and I'd like to add a new record to the subform. That bit is not so bad.

I need to get info from another table to fill in on the new record when it's created.

So do I open two record sources with SQL get the values from one record then add the new record to the other source, then fill in the values from the first source and close off?

Or is there an easier way to do this?

TIA

 

[JimRich]

A query based on the relationship between the two tables will do the job quickly and easily. If there is no existing relationship you can establish one in the Design View of the Query Object.

Jim