>Rowsourcetype should be 'fields'. Rowsource should include alias, e.g. "table1.lname,ss_num,dob"
>
>Can I reissue a quest? I have a form with this listbox and the problem I have is this: When it runs I get this error:"Error loading file-rowsource record number 4 'field' phrase is not found.
>The bound file is a temporary file with and alias called 'somerecs' and the listbox should display lastname,ss_num,phone,dob. The rowsource lists these one after another verbatim lastname,ss_num,phone,dob. The rowsourcetype is fields.
>Is this enuf info to go on?
Firstly, it's not reissuing, it's actually new question.
Secondly, you just made a mistake typing Listbox.RowSource in Property Sheet. So, open Form Designer and retype it. If you are really interested to know beforehand what you really typed, then you can open SCX file manually and read record #4.
Third, when you will type in, look at my previous replies how to do it right (it should retain alias).
Edward Pikman
Independent Consultant