General information
Category:
Forms & Form designer
>If you're planning to append the data as new records in a table, then either INSERT or APPEND will do. Use the RecordSource of the grid, and SCAN it (or use a do while loop if it's faster) adding the data one record at a time if any field needs to be changed. If it's just a matter of adding all data in cursor/view/table A to table B, use APPEND FROM.
>
APPEND FROM is what I want to do. It is a view. I can't seem to get the syntax correct.
I have tried:
SELECT EquipMeter
APPEND FROM ThisForm.Grid1.RecordSource
and
SELECT EquipMeter
APPEND FROM ThisForm.Grid1.RecordSource()
Many thanks for your help.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only