Search results

Ok I’m coding a form, heres what I have done so far Me.FN LN =DLookUp("[First Name] & ' ' & [Last Name]","tblStaffID", "Staff ID=" & Me.Staff ID") I have a txt box to imput the Staff ID number in to and I want it to return the first and last name in to another txt box Am I close??? What am I...

Haya all, I’m new to access and I’m trying to create a database for my boss, but am a bit stuck, it’s a Bundy clock system in access, I have the tables set up (I think), and what I’m stuck on is building a form where, when I put in the employs ID and press enter there name appears underneath...