LevelThought
MIS
Having major issues with trying to setup a subform on a page within a multi-tabbed form on a Microsoft Access 2000 database that will only display the accounts assigned to the particular employee.
Currently using a global variable. Considering switching to using the Windows login name.
Questions:
What would be the preferred steps to setup a subform on a multi-tabbed form. Then, setup a listbox on the subform that only displays the accounts assigned to the employee. Finally, setup another form on the same page of the multi-tabbed form that is synchronized with the account number from the listbox. Upon clicking on the record on the listbox, the related fields are displayed within the other form.
Thanks in advance for any insight to this pressing problem.
Currently using a global variable. Considering switching to using the Windows login name.
Questions:
What would be the preferred steps to setup a subform on a multi-tabbed form. Then, setup a listbox on the subform that only displays the accounts assigned to the employee. Finally, setup another form on the same page of the multi-tabbed form that is synchronized with the account number from the listbox. Upon clicking on the record on the listbox, the related fields are displayed within the other form.
Thanks in advance for any insight to this pressing problem.