Display data in a form


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!!

Comments

  • :
    : 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!!
    :

    can you upload your project as an attachment?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion