brucemc777
Member
- Local time
- Today, 09:44
- Joined
- Nov 1, 2012
- Messages
- 54
Thanks for considering my nightmare-
I am using a continuous form for data entry where each record has only two user entry fields and a row of two fields constitutes a record.
It is generally probable that when the user is inputting there would be five to ten records at a time to input.
I do not want the next record entry line to show up until both of the prior record fields are populated, even if this means turning off a setting in the process and the user having to click a button to add another entry (which, frankly, is preferable), so no item is missed.
I will likely be conditionally color coding each row as an additional notice to them (her...). (No, that is not an insult to the person in question who will be doing the inputting, only my fear of mistakes that could be complicated by the next record opening for input prior to the present being completed - i don't want any congestion nor distraction until each record is completed.)
Though i am getting better at this (Access and VBA), i still am doing a lot of trial and a lot more errors which gets frustrating, but i hope it is the best way for me to learn as i do-
Thank you for your thoughts!
-Bruce
I am using a continuous form for data entry where each record has only two user entry fields and a row of two fields constitutes a record.
It is generally probable that when the user is inputting there would be five to ten records at a time to input.
I do not want the next record entry line to show up until both of the prior record fields are populated, even if this means turning off a setting in the process and the user having to click a button to add another entry (which, frankly, is preferable), so no item is missed.
I will likely be conditionally color coding each row as an additional notice to them (her...). (No, that is not an insult to the person in question who will be doing the inputting, only my fear of mistakes that could be complicated by the next record opening for input prior to the present being completed - i don't want any congestion nor distraction until each record is completed.)
Though i am getting better at this (Access and VBA), i still am doing a lot of trial and a lot more errors which gets frustrating, but i hope it is the best way for me to learn as i do-
Thank you for your thoughts!
-Bruce