Can't get Query updatable

[boblarson]

Are you sure you don't have BREAK ON ALL ERRORS checked in your VBA properties? It works fine for me and any errors are dealt with by the error handlers. If you have BREAK ON ALL ERRORS checked then you would get these error messages but if not then they should just be handled.

 

[davesmith202]

It worked and its quite fun too!

 

[davesmith202]

Ok, I have uploaded the file at the following link:

www.logme.info/Test v5.zip

I've hated working on this database because it was adapted by a non-programmer from a Microsoft template. Yuk!

 

[boblarson]

Ok, I have uploaded the file at the following link:

www.logme.info/Test v5.zip

I've hated working on this database because it was adapted by a non-programmer from a Microsoft template. Yuk!

I will check it when I get home in about 8 hours. I do not have 2007 here at work so I can't do anything until then. If anyone else DOES have 2007 and wants to attack it sooner, feel free.

 

[davesmith202]

Let me be clear...

On the Student Information form that opens on opening the database, click the Courses tab. The idea is your can pick off a FacultyID and it will populate the field for that current student.

 

[boblarson]

I'm running out of time as I look at this tonight and try to figure out how I can make your subform work. You have some pretty serious design flaws in the data structure and that is complicating matters. But unfortunately I won't be able to look further until I get home tomorrow night. I wish I could do it in between things at work but unfortunately I don't have 2007 there.

 

[davesmith202]

Thanks for your help Bob. I appreciate the design flaws, which is one reason I hate working on existing projects that a non-Access designer has created. Eugggh!

If you do have any ideas, much appreciated.