Hello,

I have 2 tables in my SQL Database, one which holds a list of a persons details, and another which holds the persons reference and access number.

For example, in table 1 (tbl_Personal) I have :

Ref-Forename-Surname-Age-DOB-etc.....
112-Joseph-Bloggs-29-21/12/1977
123-Lucy-Winter-27-05/06/1979

In table 2 (tbl_Access), I have :

Ref-AccessNo
112-258
123-369

On my form I have a combobox which brings in the persons surname from tbl_Personal.

If I select a person from this box, I want the box underneath to populate with the persons accessno from tbl_Access.

How do I do this please ?

Thanks,