Thanks for your reply. I found the problem. I had an incorrect join in the query for the record source of the form. I was trying to look up a trailer that had not been delivered yet and my record source had an inner join between the primary table and the delivery table. So the combo box could find the record because it was just based on the primary table but the query couldn't because of the join. I changed it to a left join and now it works. Hope things are good in Paris. Having you done any traveling lately?
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Posted by: email@example.com
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (5)|