Autofill question

[Rican]

Hello everyone, I'm creating a form for a help desk type of database. I have the users list down on a combo box in the form. I want the form to automatically fill in the user's extension, workstation id, userid, etc when I select the user from the drop-down list. Is there a way to do this without too much coding? I'm not really good with VB and just started using access about1 month ago... Any help would be appreciated... Feel free to send any 'sample' scripts... TIA

 

[Idjit]

I assume you already have this information entered into another table and what you want to do is display it? If so, the simplest way to do this is with a subform.

 

[Rican]

I do have the info in a table... A subform?

 

[Idjit]

Yes. A subform is a form-within-a-form. There is a wizard that will help you create one. If you're not familiar with subforms, do a search on "subform" in MS Access Help to learn more. I also recommend picking up a self-help book. There are many to choose from and they make great reference manuals.

 

[WayneRyan]

Rican:

Assume that you have:

tblProblems:
ProblemID
ProblemDate
ProblemDescription
UserID

tblUsers:
UserID
Workstation
Extension

On your main form you can use fields bound to tblProblems.
You can make a combo box with 3-columns and a RowSource:

Select UserID, Workstation, Extension
From tblUsers
Order By UserID

Bind the first column to tblProblems.

When you do reports, etc. you will just add in the tblUsers,
join them on the UserID and use the values in tblUsers. This
way if someone changes workstations or extensions, you will
not have a mess.

Wayne

 

[Rican]

Thanks Wayne... I will try and do this... I do have a tblInfo with all the user's information and a tblUserLog which is the one that has the info after they call the helpdesk... I tried the subform thing above and it didn't work the way i need it... Thanks

 

[Pat Hartman]

You can do what you want without ANY coding. Look up "autolookup queries" in help. You can also search the archives here for additional info.