I have a continuous form with a field called FIELD1. I have written some code that would select records from a table (one or more records can be selected). How can I update FIELD1 with the records that were selected from the table. Remember it is a continuous form and when you initially enter the form you only see one row.
When I run the code I am getting more than one record but in the form I am only seeing the last record.
You can use the RecordSource property to specify the source of the data for a form or report. You can display data from a table, query, or SQL statement.
now i can agree that there are times when an array is nice, and i even have a big app that refers to a huge array of mock-constants pulled from a table, but the array is only there for intermediate calculations - it is never displayed.
an access table is ...an array. simplify your life - instead of your array use a temporary table. use your SQL to maketable. make some more SQL to delete *.