Auto populate Primary key in a form based on user selection in 3 dependent combo boxes

[ANKUR JAIN]

Hello Friends,

I have a table with 4 fields viz Employee ID (Primary key), FirstName, Surname and Date of Birth. The combination of Firstname, Surname and DOB is UNIQUE.
My objective is to find out the Employee ID. I have designed a form which has 3 DEPENDENT combo boxes for Firstname, Surname and DOB respectively.


I expect that after updating the 3 combo boxes a textbox should autofill to reflect the Employee ID. How should I approach this.?



Regards

[orange]

Using an autonumber datatype for your Employee ID is one method.

[June7]

So you need a search/filter process? Review http://allenbrowne.com/ser-62.html

Or use a single combobox that includes EmployeeID and concatenates other fields.

RowSource: SELECT EmployeeID, Surname & ", " & Firstname & " " & DOB AS Emp FROM Employees ORDER BY Surname, Firstname, DOB;

ColumnCount: 2
ColumnWidths: 0";2"
BoundColumn: 1

Now the EmployeeID is available for whatever you need it for.

[ANKUR JAIN]

Yes, I need a search/filter process. I am aware of the method of using a single combo box but it is required to work with 3 combo boxes. The link shared seems to be addressing my problem but since I am new to MS Access I am finding it difficult to understand.
Anyways, thank you for your support.