Populate new record with search results

[Ruegen]

I've just started on adding records to a subform however I want to make it easy for the user where if first allows them to search for a record in a search form and then add that record id to a new record in the subform they are currently on.

I'm thinking it should carry over the searched ID and then return it to the form.

[Ruegen]

Nevermind - found solution

[RuralGuy]

Care to share your solution with others that read these forums?

[Ruegen]

Care to share your solution with others that read these forums?

I made the button popup open with an openform to "add" and gave it the same query. I put in a search sub for the list and for every click action on the result I used vba to make the blank id field = the clicked id field.

Me.Parent.frmBookingJoiningSearchSub2.Form.NewScho olsID = Me.NewSchoolsID

for those who want to know

me.mainform.subformwithsearchresults.Form.ID = me.MainformID (which happens to be blank because it's an add opened form).

[RuralGuy]

Thanks. I marked this thread as Solved for you.

[Ruegen]

ah thanks