I have 3 forms one for adding, one for editing and one for doing ratios (basically the same form but different buttons and information. The tables behind these forms are the same, but they are coming from different queries. There is a button on my add form which takes the user to the edit form. My edit form has a drop down list that searches for Bill of Lading numbers (BL#). But every time one form is open behind the other form, my data does not move or change. What could be causing this? The user has to close the forms and open them one by one in order for everything to work fine, which defeats the purpose of having buttons on each form to go to the other forms. I hope I explain this clear enough! Thanks for your help in advance.