the problem that I am having was that the list box when I attempted to select does not contain any values. the list box is sourced from query.
this is the query from the property sheet row source of the emp_hdr_id list box:
when I removed property column widths it is displaying id but not the name . please help thank you.Code:SELECT tblEmpHdr.emp_hdr_id, [tblEmpHdr].emp_fname & ", " & [tblEmpHdr].emp_lname AS emp_name FROM tblEmpHdr ORDER BY tblEmpHdr.emp_lname, tblEmpHdr.emp_fname;