this is my code:
strSQL = "SELECT contacts.contact.id, contacts.postalcode, contacts.city, contacts.firstname, contacts.lastname, contacts.state, contacts.day_phone, contacts.evening_phone, contacts.budget_range, contacts.new, contacts.used, contacts.length, contacts.date_of_birth, contacts.salesperson, contacts.ctl1st, contacts.ctl2nd, contacts.ctl3rd, contacts.ctl4th, contacts.phone, contacts.walk_in, contacts.referral, contacts.show, contacts.advertising, contacts.source, contacts.insert, contacts.ad, contacts.newspaper, contacts.show_name, contacts.referral_name " & "FROM Contacts"
strWhere = "WHERE strWhereValue;"
strOrder = "ORDER BY contacts.contactid;"
'Pass the SQL to the RowSource of the listbox
Me.RecordSource= strSQL & " " & strWhere & " " & strOrder
With the last statement Me.recordsource= strSQL & " " & strWhere & " " & str Order i get a error saying that there are characters after the sql statement and i don't even have a space there. what do you think?