Hi,
I have an Access 2000 DB with a form with a 4 page tab control that I use to enter data into a linked table in an MS SQL 7.0 database.
The problem I am encountering is that when you have gone through all the fields on a page and then hit the TAB key (normally this would take you back to the first field) it reports an ODBC call fail. The ODBC call fails because some of the other fields on the other pages of the tab control are set as 'required' in the SQL database and so Access cannot complete it's INSERT query while those values are not specified.
Is there any way to stop Access trying to do the INSERT query after you reach the last control on a page?
Or, cannot anyone provide me with another workaround for this.
Thanks for your help
Craig Shepherd
I have an Access 2000 DB with a form with a 4 page tab control that I use to enter data into a linked table in an MS SQL 7.0 database.
The problem I am encountering is that when you have gone through all the fields on a page and then hit the TAB key (normally this would take you back to the first field) it reports an ODBC call fail. The ODBC call fails because some of the other fields on the other pages of the tab control are set as 'required' in the SQL database and so Access cannot complete it's INSERT query while those values are not specified.
Is there any way to stop Access trying to do the INSERT query after you reach the last control on a page?
Or, cannot anyone provide me with another workaround for this.
Thanks for your help
Craig Shepherd