getting fields to populate in my form 1

[kellybw]

Please bear with me, I'm new to this......I am trying to get my form to do an auto lookup. I have fields from a table that includes employeeid, lastname, firstname, department, and hiredate on my form, what I would like to happen is, when I type in an employeeid number, have the firstname, lastname, etc fields automatically populate with the correct data from my employee table. Would an auto lookup be the best way to accomplish this? At this point I am open to any suggestions. Thanks!!

 

[PHV]

Take a look at the FAQ area in this forum.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kjv1611]

There are probably a few FAQ's that would help for this, but you could also try the DLOOKUP function in VBA. Just open the VBA code window, hit the Help button, and type in [BLUE]DLOOKUP[/BLUE] in the Answer Wizard. That will give yout the correct format and all. That function along with the DCOUNT function have been very helpful to me.

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[PlumDingo]

I have the same question as the original user. I have looked in the FAQ section and I don't know where to start. I am trying to have someone use a form to bring up information about an employee when they type in their last name or Employee ID.

 

[PlumDingo]

I got it!! Thank you kjv. The Dlookup works great!!