none
auto populated field in forms RRS feed

  • Question

  • There are two tables in my database. One is courses(CourseID, course name) and the other one is student(StudentID, Student name, CourseID, course name). So I want to create a form for this student table in which whenever I enter <g class="gr_ gr_365 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace" data-gr-id="365" id="365">courseID</g> value the course name should be automatically displayed in the <g class="gr_ gr_524 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace" data-gr-id="524" id="524">coursename</g> field. To do this I created a relationship between these two tables and also created a trigger called "After update" on <g class="gr_ gr_1009 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace" data-gr-id="1009" id="1009"><g class="gr_ gr_1028 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="1028" id="1028">courseID</g></g> attribute of student form. what this does is, it fills the <g class="gr_ gr_1248 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace" data-gr-id="1248" id="1248">coursename</g> attribute value in the form based on the <g class="gr_ gr_1339 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace" data-gr-id="1339" id="1339">courseID</g> which I have entered from courses table. This works fine when I create a new program for this but the problem comes when I reopen my access program. It just doesn't work at all. Does anyone have any idea why this happens?


    Thursday, September 13, 2018 7:33 AM