Copy a query result to a form

[vgreen]

Hi All:


I am very new to access and have created a database that is supposed to be used for customer service reps to call various customers. There are certain fields on the form that are pre-populated from a report that I ran using a separate application. However on the form I have inserted a button which opens up another form which allows you to search for varioius individuals based on a zip code. The results appear in a subform embedded in this search form. I would like to somehow select one of the query results to populate the previous form. Is there a way for me to do that by either copying the record or using some other function? I am an Access novice and have no programming experience (i.e. SQL), so if there is a way for me to do this by navigating the Access GUI that would be great! thanks in advance for your help.
-vgreen

[June7]

Use VBA code to execute an SQL INSERT action. Perhaps in a button Click event. Example showing text, date, number datatypes:

CurrentDb.Execute "INSERT INTO tablename(fieldname1, fieldname2, fieldname3, etc) VALUES('" & Me!fieldname1 & "', #" & Me!fieldname2 & "#, " & Me!fieldname3 & etc & ")"

Then refresh the first form to display new record.
Forms!formname.Requery

[vgreen]

I do not mean to sound slow, but I am completely confused by the response. As I state earlier I am not a coder, is there a way that you can explain this to me in laymens terms or step-by-step? Thanks for responding to me with your feedback.

[June7]

1. Create a button on the second form.
2. On the Properties Sheet for the button, Event tab, Click event, select [Event Procedure]
3. Click the ellipses (...) to open the VBA editor in the procedure
4. Type code. Use your actual field and form names
CurrentDb.Execute "INSERT INTO tablename(fieldname1, fieldname2, fieldname3, etc) VALUES('" & Me!fieldname1 & "', #" & Me!fieldname2 & "#, " & Me!fieldname3 & etc & ")"
Forms!formname.Requery
Me.Close
5. Test and debug (refer to link at bottom of my post)

Google: Access introduction to programming

Review
http://office.microsoft.com/en-us/ac...010341717.aspx
http://www.access-vba.net/