Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011

    Question Unanswered: generate autonumber in main form from subform?

    hello sir,

    usually if i enter any data in main form auto number creating,
    but how i can create auto number from subform, i mean if i enter data in subform autonumber should create in main form ?

    thanks in advance


  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Quote Originally Posted by alex_raju View Post
    if i enter data in subform autonumber should create in main form ?
    Only if both forms are based on the same table/query or it they both contain a reference to the Autonumber column of the table.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Im assuming you have a parent / child realtionship with the autonumber in the parent tabel / form, used as a foreign key in sub form / child table.

    in the usual Access design paradigm you'd be expected to start data entry in the parent form, and that should trigger the autonumber.

    you may be able to get a new unique autonumber in the parent form by forcing an addnew event in the parentr form from the childform.

    I suspect the real soluiton in the access environment is user training.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts