Hi, I'm trying to build a database for a farmer friend. It's quite a complicated db but for simplicity's sake say I have two tables, one contains details of cows, the other contains medical details of the cows. I've got a form that will allow the user to input a cow's number (also the primary key btw) and I want another form to open that has the cow's medical history in a non-editable datasheet, and the option to add a new medical record. The way I've tried it I can pass the chosen cow number as a variable and I get the correct datasheet(with the cow's medical history) but the form below also has existing records for that cow, instead of a blank form for the user to add the new medical record. The subform won't let me add a report! Please help!!