I tried a local view last night, there are some very import criteria for the records. The screen set is actualy two screens, each with it's own criteria, and the user must be able to switch quickly between them. The problem with setting the view with a variable for the main window is re-assigning the variable. The primary key (item_no) is a text field, with numeric data (101, 102, -- 130, 201 etc) that is sequential, but not nessicarily numericly sequential. A bit of background: The application is for a charity TV auction. Each record on display has the item being auctioned, its value, a photgraph of the item, the name of the company that donated the item and a photo of the company. There are on average 30 items auctioned off in an hour, and the numbering is formated HOUR/ITEM. Thus hour 1 item 12 would have a number 112.
Passing a new argument to requery() then becomes problematic.
The second form in the form set must have all of it's data loaded, (78 records in 123.nnn seconds usual load time, P133 64 MB ram) but that screen only has one photo per record(donor)
By only loading(fetching) a limited number of records, which I would prefer, there would be no need for the variable in the view, as the recordset would be open in the correct order.