Teri Bridges
Member
- Local time
- Today, 17:12
- Joined
- Feb 21, 2022
- Messages
- 186
Hi, I have yet another question. I have a sub form that list courses by developer. So this form shows a list of courses assigned to the developer. What I want to do is open the main course form to the specific course when the user clicks the course ID in the sub form.
So what I am attempting is when the user looks at their assignments and sees course ID 3 they click on course ID 3 and the main form opens to Course ID 3
I can get the main course form to open using
DoCmd.OpenForm "frmCourseDetails", WhereCondition:="[CourseID]=" & Me!CourseID
But the main form opens to new record.
I do have the on load set on the main form to open in new record so I am sure it has something to do with that, but I am not sure what I need to do to fix it.
I do want the main form to open to new record if the user is not accessing through the sub form. I hope this makes sense.
So what I am attempting is when the user looks at their assignments and sees course ID 3 they click on course ID 3 and the main form opens to Course ID 3
I can get the main course form to open using
DoCmd.OpenForm "frmCourseDetails", WhereCondition:="[CourseID]=" & Me!CourseID
But the main form opens to new record.
I do have the on load set on the main form to open in new record so I am sure it has something to do with that, but I am not sure what I need to do to fix it.
I do want the main form to open to new record if the user is not accessing through the sub form. I hope this makes sense.