Thank you, SSanfu. This works very well and seems to do everything that I that I want it to do.
Thank you, SSanfu. This works very well and seems to do everything that I that I want it to do.
Hello again SSanfu;
I just duiscovered that if I click on "No" when asked if I want to add new record, I get the following error: "Run-time error '91' Object variable or with block variable net set". When I click on debug, the line "rs.Close" is highlighted. I'll work on trying to find the problem, but thought that you might have run into it before. BTW, clicking on "Yes" to add the new record works flawlessly. Thanks again.
Hello Ssanfu:
I was able to fix the problem and all is working well now. It seems that the last three lines of code before the End Sub (i.e. "rs.Close", "Set rs = Nothing" and "Set db = Nothing") should be before the last End If command. Placing them there caused the routine to run flawlessly. Thanks again.
You are correct. I looked at "The ACCESS WEB" page and the last three lines are in the wrong place there. Good catch.Hello Ssanfu:
I was able to fix the problem and all is working well now. It seems that the last three lines of code before the End Sub (i.e. "rs.Close", "Set rs = Nothing" and "Set db = Nothing") should be before the last End If command. Placing them there caused the routine to run flawlessly. Thanks again.
Glad you were able to fix it.