PDA

View Full Version : Auto Populate Field with infor from another tabel when Ref is entered



mykal66
10-17-2016, 05:39 AM
Hi

Very very new to Access but trying to put something together for work which isn't brilliant but does the job but struggling trying to get a filed to auto populate a name when the user enters an ID.

What i'm trying to do and any help at all would be very much appreciated. I've google and found several answers but because i have no clue i cannot get it to work and unable to upload my example DB

I short my DB has tables / forms EMPLOYER & ISSUES both of which hold the ERN (number) and Name (text). I am trying to get the ISSUE form to automatically add the Name when a user enters the ERN (to prevent multiple spellings of the same name)

jonh
10-17-2016, 09:02 AM
Use a list or combo box to display the names on your form but record the ERN number in the table.


Assuming employer is the table,

control source = ERN
Row Source = select distinct ern, name from EMPLOYER
column widths = 0

mykal66
10-17-2016, 11:10 PM
Thank you mate i will gove it a go.