Problematic ‘Edit’ code in Multiple Page Userform

Dear All,

I should be very grateful if you would, please, help me tweak the ‘Edit’ code so that it will work correctly my Multiple Page Userform.

With some help, I have been able to put together a Multiple Page Userform (two userforms combined together) – one for Students and the other for Employees.

I am having problems getting the ‘Edit’ code to work for the ‘Employees’ userform. It works OK for the ‘Students’ userform.

1. When for e.g. a letter ‘e’ is typed into the ‘Filter Combo box’, the ‘Lookup Criteria’ box is automatically populated with the list of records containing the letter ‘e’.

2. And if e.g. the record of a student is clicked in the Lookup Criteria box, the ‘Student’ userform is populated with the full records of the student from the database. So also if the record of an employee is clicked, the ‘employee’ userform is equally populated.

3. However, when a user populates the student userform with a student’s record, and then amends the student’s record and clicks the ‘Edit’ button, the said student’s records are correctly updated.
4. The ‘Edit’ button is supposed to work for both userforms.

5. However, when a user populates the employee userform with the record of an employee and then amends the employee’s record and clicks the ‘Edit’ button, the ‘Edit’ code seems not to work correctly for updating such employee’s record.

Please, I need help to tweak the ‘Edit’ code for me so that it will work for both the ‘student userform’ and also the ‘employee userform’.

I have attached to this thread a sample file of the said Multiple Page Userform (with the codes). I am also appending below, the problematic ‘Edit’ code, and should be grateful for your kind help.

Please Login or Register  to view this content.

Thanks Norie for your kind response. Yes, employee records are not being updated when you click the ‘EDIT’ button. For eg.

1. When you activate the attached sample file (the Userform), you will observe that there are two sides to it – the Student Userform and the Employee Userform.

2. At the top of all these are the ‘Filter combo box’ and the ‘Lookup Criteria Box’. These are common to both Userforms as you will observe.

3. If you click for eg. on the Student Userform, and type say ‘e’ into the Filter Combo box, the Lookup Criteria Box gets populated with the records (names, etc.) of everybody – students and employees, respectively – that has the letter ‘e’ in their names.

4. If you then click on the record of any student (and given that you are on the Student Userform), the records (full details) of the student you have clicked will populate the Student Userform.

5. While the Student Userform is populated, a user can change/alter any bit of that student’s details from the userform.

6. If you do so and click the ‘EDIT’ button (which serves as the ‘Update’ button, the said student’s record will be updated with the change(s) made. These changes will automatically show in the Lookup Criteria Box and also be reflected in the Database. This Update process (using the EDIT’ button) works OK for the Students userform/records.

7. If, on the other hand a user decides to do the same thing (3 to 6 above) on the Employee Userform, the EDIT button does not update any changes made to any employee’s records, and the Employee’s record is also not updated in the Database.

I believe that the EDIT code needs tweaking to be able to work correctly for the Employee Userform as it does for the Student Userform, as explained above.

I need help with the EDIT code to achieve this, please.

Thank you

Buddy8.

Hi Tinbendr,

Thanks very much for your kind response and for your observation.

As I indicated in my first Post, I had so much help with respect to the coding. My VBA knowledge and skills are very basic and I am always willing to learn.

I don't know how to tweak the Employee controls to take account of what you pointed out. I should be very grateful if you would, please, help me out with that.

Thanks for your help.

Buddy8

I'll appreciate help with this, please.

Thanks all.

Buddy