Hi,
My form has a single tab control (2 tabs total) but will not save a record to my QUERY unless certain parts of BOTH tabs are filled out. I need to be able to have only the first part of the query be filled out while writing to the query & table both. My tabs are each based on different tables linked by a common index, so this means if the first tab is complete but not the second the query shud have a record written to it with blanks set against the fields that come from the table whose tab on my form was not filled out. Hope I made sense and someone can help.
Thanks!

Queries are not persistant objects. You don't write records to them. You write records to tables. You might be able to solve your problem if you force Access to save the current record when you leave the first tab.