1. Get rid of the lookup at table level. They are BAD and cause all sorts of problems ( see here for more about that).

2. Once you've gotten rid of the lookup at table level, I think you may find that things work a whole lot better. Be sure to change your control on your report from a listbox to a text box.