Ok, so I have a form that processes traffic counts by user input. For new locations, a user has to put in a Unique GeoID and then some other location data.
Then the user needs to enter in the data in a table format (which is linked to a table called TBIVOL) based on that GeoID that was manually entered.
Afterwards a process button is pressed and the information from that TBIVOL is appended to various other tables and then the count data is cleared from the TBIVOL table other than the GeoID and Hours
Currently right now the TBIVOL table just has the hours of the day, and traffic count data that is manually imputed (Hour, NB/EB, SB/WB and Combined).
For every new GeoID created, the user has to fill in this table starting with adding a new record for each hour (1-24) so there are 24 records for that GeoID. Then the other data can be entered.
What I would like is to have a button that could be pressed, that will automatically populate the TBIVOL table with the 24 hours. That way all the user would have to do is input the actual data (NB/EB, SB/WB, etc).
Currently I have tried to make a table with a blank GeoID and the numbered hours from 1-24 and then have tried to do an append query based on the GeoID (using Forms!24-Hour Counts By Direction!Geo), but the button keeps erroring out. So was hoping there was something I could just use in VB that I could just put there rather than making a separate table and query that would just auto-populate the hours for me.
Example 1 is what the user sees if entering in a new GeoID location.
Example 2 is what the user sees if using an existing GeoID location.
I would like the Add Hours button on the right to populate the hours automatically.