Marcus, Scott (GEAE, RHI Consulting)
scott.marcus at ae.ge.com
Tue Apr 1 15:23:17 CST 2003
Charles, Sounds like you need to check the recordsource in the 'Open' event. If there are no records, you need to append the previous months recods in to this month(obviously with this months keys). I leave that SQL for you. After this you need to refresh the recordsource(I think). As for deleteing the records that were not touched, use the 'Update' event to set a field(you need to add this to your table) in the table to true. Then in the "close" event, delete the records for the current month where this field is not true.... Hope that helps. Scott -----Original Message----- From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] Sent: Tuesday, April 01, 2003 3:48 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Continuous Form - open for either this month or last month Gentlepersons and other List members, I have a continuous form that will display about 20-30 records. The customer wants to input a month and have the form open showing the records for that 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. I know this is doable, and some of you may have already done something similar. However, I seem to be suffering a senior moment since I cannot think of a way to doing the creating and saving. I am using A2K/A02 on Win2K. TIA, Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com