Recent content by thegoose

P.S However when I run the code without the "rs.AddNew" line, it works, but always imports the first appointment into Schedule, not the current one on the form!!

Sorry Still can't get it to run, Doesn't tell me that I actually have error in the code, just a type mismatch, but I have checked all the buttons and cannot figure it out. The form simply has "Session,date,start time,end time" as fields and add appointments Cmd button with AddAppt as it's...

it is ticked, tried it again, but no good... not very experienced am I missing something?

Will do, Many thanks

Wonder if anyone can help me, I am not that experienced with Access and I have been asked to design an appointment dbase..gulp! I am using the code from this help page currently and have modified it slightly as I wish to use the form as Data entry and ONLY update the current record entered. I...