of course I want to do the job properly, i have read that snippet "evils of look ups..." multiple times as people posted it in similar situations. I have read as many other posts as I could before even posting here. Remember, I am a novice, not a "VIP", so there are questions I have on your response which I need clarification:
-my form is based off of a query, not a table. And that query actually brings in text, like for Property, it says "321 Main St" its the report based off the query that just shows "1" the ID KEY for list table used in combo box to populate main table query draws from. so when you say create another query that brings in those text fields and use those instead... I'm lost.