Hello, experts,
I am learning Access and VBA by trial and error. Currently i am trying to design a database (access2007). It has two Tables. 1) tblWorkOrder 2) tblWorkPlace., one main form, frmWorkorder. This main form has a subform , frmworkplacesubform.. Data from frmWorkorder gets stored in tblworkorder and subform data goes to tblworkplace.. Another form, frmworkorderlist, displays all the records of the table tblworkorder.
i have managed to synchronize subform records to main form. but i am stuck at on problem which , even after lot of search and trial, not able to solve. Kindly help.
As shown in the attached image, when i open the frmworkorder, it opens the first record, as shown by the default navigation buttons. That is ok. but when i select another record, say record no 3, through the form frmworkorderlist, record does show in the form controls but the navigation buttons still show the first record. i am not able make it the current record.
Thanks in advance
I am learning Access and VBA by trial and error. Currently i am trying to design a database (access2007). It has two Tables. 1) tblWorkOrder 2) tblWorkPlace., one main form, frmWorkorder. This main form has a subform , frmworkplacesubform.. Data from frmWorkorder gets stored in tblworkorder and subform data goes to tblworkplace.. Another form, frmworkorderlist, displays all the records of the table tblworkorder.
i have managed to synchronize subform records to main form. but i am stuck at on problem which , even after lot of search and trial, not able to solve. Kindly help.
As shown in the attached image, when i open the frmworkorder, it opens the first record, as shown by the default navigation buttons. That is ok. but when i select another record, say record no 3, through the form frmworkorderlist, record does show in the form controls but the navigation buttons still show the first record. i am not able make it the current record.
Thanks in advance