REAL Newbie to Access - All Help needed!

[iLLmatic]

Hey peeps,
Im trying to create a access database that will allow myself to check asset details / PC's that I own within the company. I basically want to be able to select a user name and all the details for the user will appear.

I have been messing with the "Asset Wizard" - however have run into problems.. I have a very basic understanding and any help will be great!!

I have managed to import all my usernames from a excel spreadsheet, and list them as a a dropdown - however how do I make all other fields update when the username is changed ?

PLEASE help...Thanks guys

 

[ColinEssex]

Make sure that you have an Autonumber to identify each user and make that a Primary Key. The form will be bound to a query to pull the details.

Then on the form add a ComboBox with the wizard. You will get 3 options, you want the one that says "Find record based on selection" or whatever (its option3)

Thats it.

Col