Howdy, Stranger!

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

Categories

Display data in a form

KishMishKishMish Member Posts: 1

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

  • dokken2dokken2 Member Posts: 532
    :
    : 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.