Append query with a criterion, "the selection"

[Guest]

I'm sure this is easy, but I've never done this in an MDB, I've used ADB's up
to this point.

I need to write an append query that copies the "current selection" on a
form when a button is pressed. The selection is the form's recordset.

How to?

 

[John Vinson]

I'm sure this is easy, but I've never done this in an MDB, I've used ADB's up
to this point.

I need to write an append query that copies the "current selection" on a
form when a button is pressed. The selection is the form's recordset.

Use a criterion such as

=[Forms]![NameOfForm]![NameOfControl]


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps