Append from subform selection

[CraigBFG]

I'm attempting to create a query that will append multiple records to a second table based on the selection from a subform (datasheet view).

However, when I run the query, it only appends the first record in the selection, ie lots are greyed/selected but only one record seems to be arrowed/selected.

How can I append multiple selected records?

Many thanks
CraigBFG

 

[WayneRyan]

Craig,

You can't have multiple Current records. If you want to select multiple
ones, then you'll need a listbox (multi-select) and you'll have to construct
the SQL for a query by using VBA.

Much easier than it sounds and there are examples here. Use the Search
Facility and look for "listbox".

Wayne