AutoFill on Entry of Number

[Elvis72]

OK, maybe I'm having a really long blonde moment...

I have tried a Dlookup to do this and its just not working.

Main Form -

Project Services Information

Sub Form -

Personnel Assigned to Project

The subform pulls from a resume table and a project information table to create a record that includes:

Worker ID First Name Last Name Cell Phone Email Address Role Hourly Rate Job Number/Proposal Number

The Subform is pulling the personnel that are associated with the Job Number/Proposal Number.

What I need to do is have it where when someone inputs a Worker ID number it will auto populate the First Name, Last Name , Cell Phone, Email Address from the Resume Table to create a new record in the Query.

I have done this before so I know its not that difficult...as I am no Access/Coding Guru.

Any help is GREATLY appreciated!~

 

[KenReay]

How about a multi column combo box on EmployeeId, you can then display the Name etc, using construct like =cboEmployeeId.column(1)

you have to adjust the column index (1) im my example depending on how you have structured the query of the combo box, this way you do not need any VBA code

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[Elvis72]

I don't think this allows me to make edits, which I need to be able to do?

If I input 1000 into the worker id field I need the rest of the fields populated so I can create a new record for role and hourly wage.

If I'm not calling this the right verbage please let me know!~

Thanks so much!~

 

[KenReay]

Hi

OK, if you want to be able to edit the columns, then populate them in the after update event of the combo box, using code like:

MyName = cboEmployeeId.Column(1)
MyHourlyRate = cboEmployeeId.Column(2)



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK