Thanks Paul, still no luck!!!
I tried the new code and still get the error...
The above I have provided is an example of what I'm trying to do.
I'm actually using different fields and tables but the context is the same, I even renamed my second table from DWR_Sequence to DWRSequence in case it...
Hi Paul,
Sorry my post must of come across wrong - it's already in a VBA module on the "ON Click" event of the button. It's a private sub - but are you suggesting to use a private function instead?
Thanks
Luke
I have a problem when using ADP connected to SQL Server 2000 that works fine when using a plain and simple MDB file.
I have a field that I want to increment based on the last value in the table but matching the linking field between the 2 tables.
I.E. a DVD could have 10 reviews of which it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.