Recent content by speedyjhg

I found a workable solution - I just needed to look a little longer. It's a bit clunky, so if someone has a better idea, please point me in a different direction. I used a delete query, then an append query (with everything but the project answers), then an update query (with project answers)...

I'm still new to VBA but I don't think "Null" is what you wanted. My understanding is that when forms are opened values are nothing or empty. Here's a reference if you're still looking for a different solution. http://allenbrowne.com/vba-NothingEmpty.html

It sounds like something you can accomplish in a subquery Here's a good reference: http://allenbrowne.com/subquery-01.html

After several months of poking around this site and getting all my questions answered, I finally have some specific questions that I can't find the answer too. Hopefully I can ask the right questions, so that I can get some help. I'm familiar with access and everything I know about VBA I've...

One other piece of data - I'm using Access 2000

Problem: I need to filter the a series of questions by subcategory and associate them with the project specific answers. How do I do this and not get a non-updatable query? Questions can be in multiple subcategories and each project answers all the questions. Background: I work in an...