wolfspecter13
New member
- Local time
- Today, 16:42
- Joined
- Nov 24, 2012
- Messages
- 5
I am a VBA neophyte but already have one form - based on a student name-and-ID table (not a query) running fine. Access 2010, Windows 7.
I created a new form, very similar in format, but based on a simple query that allows me to input the course # (###) when the form loads. Works great, just the kids I want in that roster show up.
I have 2 questions. (1) How do get the form to allow me to change/enter a new parameter value without closing the form and reopening it? I tried adding a button to run the base query again, but I get a datasheet with the query elements in it, all blank.
(2) I tried to use the "reset" button code I have working in the other attendance form, to reset all the "TempAttendance" checkboxes to default=No but it is not working in this new form. I looked at the VBA code and tried to adapt the names for controls where I could, but I must be missing something.
I need advice but I do not think this is too difficult to fix.
Attaching two Word docs with the VBA from both forms and the form design layouts, plus the new query that displays a single roster, upon which the new form is based.
I am thankful for any help anyone can offer!
L B TagueView attachment VBA from the new form Part 1 of 2.doc
View attachment VBA from the original form Part 2 of 2.doc
I created a new form, very similar in format, but based on a simple query that allows me to input the course # (###) when the form loads. Works great, just the kids I want in that roster show up.
I have 2 questions. (1) How do get the form to allow me to change/enter a new parameter value without closing the form and reopening it? I tried adding a button to run the base query again, but I get a datasheet with the query elements in it, all blank.
(2) I tried to use the "reset" button code I have working in the other attendance form, to reset all the "TempAttendance" checkboxes to default=No but it is not working in this new form. I looked at the VBA code and tried to adapt the names for controls where I could, but I must be missing something.
I need advice but I do not think this is too difficult to fix.
Attaching two Word docs with the VBA from both forms and the form design layouts, plus the new query that displays a single roster, upon which the new form is based.
I am thankful for any help anyone can offer!
L B TagueView attachment VBA from the new form Part 1 of 2.doc
View attachment VBA from the original form Part 2 of 2.doc