[AccessD] Continuous Form - open for either this month or last month

> 
 But if there are no records for that month,
> they want the form to open showing new records created from the previous
> month and only showing some of the data in each record.  The rest of the
> fields are to be blanked for input.  When the customer is finished
> entering data into these records, all the records with data entered are
> to be saved and the others not saved.
> 
Sounds like the place for a grid control and an unbound form :-)

Alterntviely, you'll have to populate a temporary table with the necessary data and 
change the recordsource of the form to the temp table.

On Save - update the main table from the temp table and reset the recordsource again.





-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.