Using same data for different months

[EthanMoist]

Hi all, a couple of questions about this database that I have started working on, with this forum's help (Thank you to those who have already helped!)



1) I am trying to use the same set of data for different months. I will try to explain...For each month I want to mark the data as "Statement Received" and "Statement Reconciled". I don't want to create a brand new database every month with the same data. The database will become massive too quickly. Is there any way that I can set the date by using the filter date combo box I have created on the frm_SearchMulti form and having a fresh set of data for just April. When May comes around I can create a new date and have a fresh set of data, but still reference April data... I hope I am explaining this okay

2) Would it be possible to add a column into the "SearchResults" ListBox for Statement Received and Statement reconciled? I would want to update it through the text boxes I made directly above it. The buttons right now do not do anything... they are just there for formatting purposes. I want want to be able to select multiple record in the listbox and update them all simultaneously

3) How can I make the "New Account" button actually pull up a new account?

Thank you as always for your help!

05.23.2013 Account Database.zip

[June7]

I suggest not showing column heads in the comboboxes.

1. Not sure what you want. If you want to create a new set of records for May that use the data from April records, yes that can be done.

2. Code can save the Received/Reconciled dates into record and then requery the listbox to reflect the saved data. Why not using a data entry form?

3. What do you mean by 'new account'? The search form is not bound to records.