I have a form that when you enter a customers name a subform will be populated with the customers prior orders. I'm assuming this is a requery issue but I can not get it to work. The only way I can get the subform to populate is by switching to the design view and back to form view again, then the prior orders are shown. I've tried a million requery statements but I keep getting an error stating unable to find the form I'm referring to. I have tried different form names but that hasn't helped either. Any suggestions?