Daily data collection with constant elements

[cbkebasen]

Hello. I hope someone here has had experience designing forms based on the following:

I have a table that is populated everyday, with following columns:
1. ward (linked to the wards table)
2. date
3. number of patients

We have a total of 18 wards, wherein the daily number of patient in each ward should be recorded. The problem we face is that we find it counter-productive if the data encoder selects a specific ward (dropdown list), then puts the number of patients, and then moves to another field repeating the process. (the date is pre-selected using a combo-box and this will fill the date fields, thus the encoder selects the date only once).

I was wondering if there is a way where we can just automatically show all the wards, so that the data encoder would just proceed on putting the figures.

any advice is welcome. thank you!

 

[Mr. B]

One way to accomplish what you want is:

First, I am assuming that you have a table that is designed at a minimum to have an AutoNumber field for record ID, a date field, a ward field and a patient count field.

When the encoder is ready to enter the patient count for each ward, have VBA code that will create a new record in your table for each ward, populating the date field with the current date. Then use a form to display the 18 new records having the Ward and date fields to be read only and only the patient count available for data entry.

When all 18 patient count fields have been populated a button would become available and the user can save their updates to the 18 records.

I am sure there are other ways to accomplish this, but this is one way to only have to enter the actual patient count and make it simple yet quick.

Hope this helps.

 

[cbkebasen]

Thank you Mr. B for the idea, at least you've pointed me to a great direction. I have little knowledge of VBA, so I'm gonna research on how to do this. I'd appreciate it greatly if you can advise me further. Again, thanks!