Create a view of the table as SELECT * FROM table. Have the base table and the view opened in the DE. This should work OK for lookups like Comboboxes, but might get complicated if both table abnd view are read/write.
>How can I open the same table twice in a forms DE and have the same relations with other tables. The problem is that I have two combo boxes that need values from the same table. But I don't want the record pointer moving when I select a value for the second combo.
>
>Thanks
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05