Insert to Query

[cktcPeterson]

I just came across insert query while trying to find out how to copy a filed in table Applications to a specific record/field in Requested Course.

Here is what I am trying to do.

I have a form with table/query Requested Course
If the Student ID# is blank I have a pop up form people can search for their id number.

The form with a list of Students and ID numbers search page pops up.

They can select name and the ID number filters.

I want to click a command button and copy the field and past in the Requested Course form/query/table (not sure the language on that)

ideally just a copy and paste vba or macro will help, but I came across insert query and was intriqued.

Thanks!

 

[ebs17]

was intriqued

Keep that.

However, an append query always creates new data sets. A single field would be inserted into an existing record using an update query. But maybe you're just working in a bound form. This is not quite as spectacular, but highly functional and simple.