List Box problem

[wtolentino]

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:

 SELECT tblEmpHdr.emp_hdr_id, [tblEmpHdr].emp_fname & ", " & [tblEmpHdr].emp_lname AS emp_name
FROM tblEmpHdr
ORDER BY tblEmpHdr.emp_lname, tblEmpHdr.emp_fname;

when I removed property column widths it is displaying id but not the name . please help thank you.

[Preston]

When you paste that query into query design and test it, does it work?

[wtolentino]

When you paste that query into query design and test it, does it work?

yes it works


the problem is not with the query. the problem I think is how to display the second column from query and at the same time use the first column to save it on a table.

[June7]

Change ColumnCount property to 2 as well as setting the ColumnWidths.

[wtolentino]

Change ColumnCount property to 2 as well as setting the ColumnWidths.

it works. thanks so much.