Hi,
I have two tables created and link in a one-to-many relationship.
I have created a tab form (for table 1) and in one of the tab pages, I have a subform with a second tab control in it (for table 2). So far it is displaying the correct data from these 2 tables. Now when I were to click a Add record command button in the main form to add new records in the subform, it will says that I have reached end of record error. I have created a macro to be use with the add command button using the gotocontrol (subform name) and gotorecord (new) from the macro object. Can anybody helps? Thanks in advance.
I have two tables created and link in a one-to-many relationship.
I have created a tab form (for table 1) and in one of the tab pages, I have a subform with a second tab control in it (for table 2). So far it is displaying the correct data from these 2 tables. Now when I were to click a Add record command button in the main form to add new records in the subform, it will says that I have reached end of record error. I have created a macro to be use with the add command button using the gotocontrol (subform name) and gotorecord (new) from the macro object. Can anybody helps? Thanks in advance.