Recent content by pademo57

Hi Pat, Not sure what I did with the first version but no matter what I tried it wouldn't work, so I scrapped the whole thing and started again and NOW it works. Thanks for all your help.

Hi Pat, again you were right, I had the wrong RecordSource. However, now it only shows people who have been assigned a course. It doesn't show people who haven't been assigned a course. E.g. Student 1- Class 101 Student 2 - Class 101 Student 3 - Class 202 Student 4 - no class assigned...

Thanks Pat, I did try, as you suggested, making a query of the Student_Class table and then a combo for StudentID but when I click the combo it doesn't show a list, instead it shows a one line blank? What am I doing wrong?

Hi There, I have three tables: Students STUDID (pk) txtFname txtLname etc. Classes CLASSID (pk) txtClassName txtClassRoom etc. Student_Class (join table) STUD_CLASSID (pk) fk_StudID fk_ClassID I am trying to set up a form which shows a "Class" and a subform which I can add a student to it...

Thanks to all for providing answers to my question.

Thanks CJ_London, That worked just fine except for one little thing and it is probably something that I have done. I've noticed that if I have one class with 2 students in it the combo box shows the students that are not connected to that class which is great. But when I change to the next...

Hi There, I'm sure there is an easy way to do this but I have not clue. I have three tables: Students STUDID (pk) txtFname txtLname etc. Classes CLASSID (pk) txtClassName txtClassRoom etc. Student_Class (join table) STUD_CLASSID (pk) fk_StudID fk_ClassID On my Class form when assigning...

Hi There, I'm trying to add a record(s) in a join table but I'm not sure what is the best way to do this. Here are my tables: tblStudents StudID (pk) txtFname txtLname etc tblClasses ClassID (pk) txtClassName txtClassCode etc tblStud_Class StudClassID (pk) fk_StudID fk_ClassID I would like...

Argh! Hit the Submit button before answering your questions: It is sorted based on the Students ID.

Sorry, I should have been more specific. Yes, it is a custom button called "cmdbutAddRecord". I have disabled all the MS Access record navigation buttons because it was confusing to my client.

On my form I have a "New Record" button which works fine. However, the people I am working for ONLY want that button enabled IF they are on the last record. Apparently their issue is, if they are on record # 123 and press the "New" button it throws them off if the "New" record is, for example...

Thanks to everyone, a REAL NEWBIE move, I just realized what I did. In my code I put: Me.DRID - which will give me the current record instead of the new one. When I changed it to: !DRID - THEN it gave me the new record. LOL. I am laughing at myself, but I do wish to thank everyone for...

ARGH! I thought I had it but I still can't get the form to update to the new record. What happens now is that when I click the "Add Record" button it does create the new record and the program pauses for a second but goes back to the record I was at instead of moving to the new one. E.g. I on...

Oh Brother, never mind!!! I realize what I did wrong. I got the record information after the update instead of the other way around. Such a newbie move. Thanks JHB for your help.

Hi JHB, I tried as you suggested but it still goes back to the previous record. When I stepped through using F8, I noticed that when I got to the line: rs.Bookmark = rs.LastModified It was the previous record and not the one I had just added. What am I doing wrong?