Problems w/Tab Controls and Live Validations

[hhzyousafi]

I am using the Tab Control feature in Access (.accdb) and for some reason the "After Update" code is not triggering through normal means. I removed the "After Update" code and tried again and now while the code is actually triggering the live validations I have put on this particular form the data that I entered in the field vanishes. I initially made the form without Tab Control and tried incorporating Tab Control after all of the coding was done; however Microsoft's website said that shouldn't be an issue. Please help.

 

[pr2-eugin]

Hello hhzyousafi, Welcome to AWF

I should say, there is too many Access jargon, and I am lost somewhere in the middle.. How about giving another shot at explaining the problem in plain English?

 

[hhzyousafi]

Hi Paul,

Well I have a field in my system, for example "First Name", and I have put live validations on that field. For example a user cannot enter a number in the field or any special characters except "-"; all of this was working perfectly fine until I incorporated the "Tab Control" in Access. The "Tab Control" is working in a weird way. Whenever I press "Tab" after entering data the data in the field vanishes. I am having trouble controlling this. I hope that helps.

Regards,

Zohair

 

[pr2-eugin]

Tab Control? How adding the Tab control makes it to vanish the entry? I am unable to recreate your problem.. Can you please upload a Stripped DB?

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

 

[hhzyousafi]

Thank you for the help pr2-eugin. I was able to fix my problem by fixing the tab order within the tab control and setting the form tab property to "Current Record". At the end of one tab when I pressed tab the data would vanish and once I fixed the tab order the issue resolved. I am not sure how that helped but if you would still like a stripped DB I would be happy to share one with you

 

[hhzyousafi]

Thank you Pat! Again something so obvious that I just completely missed it.