Append query with a criterion, "the selection"

M

Maury Markowitz

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?
 
J

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.
Click to expand...

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
 
Top