I know this is pretty simple and I apologise but I just can't seem to get this.
I have a form that pulls infomation from one table but allows you to add new bits of information to another table.
All I want to do is when I select a passport number from the combo box 3/4 other boxes which also contain data from the same table update and show the relevant data from the same row.
ie. I pick [passport number]
[Common name] updates to show what is it.
I have seen reference to after update Event's but I am new to access (used to Excel and coding) and VBA etc is running rings round me here.
Any help much appreciated.