Recent content by mcregan

you said the problem was fixed in that posting, has this changed?

Ok, that did the trick for the problem I was having, now it hangs up at the find first command. Does my recordset need to be a query, or is it fine if it is a table? Is there a book or tool of some sort that you recomend to learn more about VBA and access in general? It seems that most of the...

it's access 2000

Yes the list of quadrants is is a separate table, and I don't think the bait will work for humans. I entered the code for afterevent. There are no longer error messages in the code, but when I enter a number in the field of the form it takes me to the VBA screen and gets angry with the Dim db...

Ok, I think I'm on the right track, but I still need a little help. I went under build event, then code builder and I entered the code you gave me and I got an error message. For the If rs.NoMatch then Exit line a error popped up that says : complie error: Expected: Do or For or Sub or...

Currently I use a form to enter data about the sale of pest bait in a given area. I want the form to alert me when I sell bait in specific sub-quadrants of the given area. So I enter the quadrant of the address baised upon a grid and if it matches a certain list of quadrants then I am somehow...