I am new to access and am setting up a db for a trust account. I have a table listing at the listed properties and a form for the listings, I have a combo box labeled status and was wondering if I change the status to pending in the status combo box if I can have it pull up a new form pulling information from the listing table to the pending form? I was using 2 separate tables but someone suggested that I only need 1. PleaseA let me know what you think.