Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User only see assigned accounts on page of multi-tabbed form

Status
Not open for further replies.
Mar 2, 2005
171
0
0
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top