I have a Userform to get data from an access data base. I have all the code written to enter a record id and then get the data from the access data base. I want to have a command button to get next record, but I can't figure out a wall to call the sub that is already written. The sub is of the from
Sub Text_Record_Num_Exit(ByVal Cancel As MSForms.ReturnBoolean)
When I try to do a call to that subroutine I get Runtime error '424' Object Required
Can someone tell me if there is a way the call the text_Exit sub from another sub or a simple way to get the next access record?
Thanks in advance for all the help this forum provides.
Sub Text_Record_Num_Exit(ByVal Cancel As MSForms.ReturnBoolean)
When I try to do a call to that subroutine I get Runtime error '424' Object Required
Can someone tell me if there is a way the call the text_Exit sub from another sub or a simple way to get the next access record?
Thanks in advance for all the help this forum provides.