Form showing employee's assigned assets

[Voodeux2014]

Hey everyone.

First off thanks in advance for the assistance. Here is the backstory. I am setting up an access database to track all of my company's assets (computers, monitors, printers, accessories, etc). I am building a database from scratch. I already have several tables to make it easier for data entry. What I would like to have set up as part of the completed vision, is a form to where you search for an employee and it brings up that employee's information as in department, location, picture so on and so forth (that table is already set up). In addition to it showing the employee's information, I would like to see what computer they have assigned to them along with the monitors and so on. What is the best way to get this done?

[June7]

Have you looked at the Assets database template?

Could use a form/subform for the info. Search for employee on main form and related assets show in subform. This could be the same form used for data entry/edit. Just add the search functionality. Options:

1. dynamic parameterized query (I don't use this)

2. code that sets the form Filter and FilterOn properties or moves to desired record
For filtering, review http://www.allenbrowne.com/ser-62.html

[Voodeux2014]

I have looked at the Assets Database. I am trying to get it to the form/subform status. Everytime I create a split form it shows information from the same table.

[June7]

That's what Split form is designed to do.

Use form/subform arrangement for records from related tables.

[Voodeux2014]

Thanks a bunch June. I don't know why I overlooked doing it that way.