Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    30

    Unanswered: Creating a New Record using Form (Last Step, Quick Answer I'm Sure)

    Hi all,
    I've reached a point with my database that I'm very comfortable with.
    My only concern is the following. Please find my attached DB in Zip format attached.
    Please go to Issuer Search -> Type in "Test Company" in the Issuer Name -> Select Issuer -> Then go to "Add New Proxy" and you go to the "frmProxy" where you can then Add in information about the Record Date, Meeting Date, and ProxyNumber.

    When you hit close AFTER updating these fields, it should create a new record that should now be visible on the frmIssuerJobs screen. (Under Annual/Special Jobs)

    Unfortunately, I can't seem to get this new record created after trying very very hard.

    Any information would be greatly appreciated!

    Thanks!
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2007
    Posts
    108
    I couldn't get your zip file to open, but I suspect the solution might be to use

    .Requery method

    ...on whatever is used to display that added record - be it form, combo, listbox etc after adding new record.

  3. #3
    Join Date
    Dec 2007
    Posts
    1
    IssuerID field is not being saved.
    Insert a new text box for ex. text11 and under
    Private Sub AnnualJobNumber_AfterUpdate()
    insert Me.Text11 = Me.IssuerID
    You can hide one of these two text boxes.
    It will save a new record.

  4. #4
    Join Date
    Nov 2007
    Posts
    30
    Quote Originally Posted by okjar
    IssuerID field is not being saved.
    Insert a new text box for ex. text11 and under
    Private Sub AnnualJobNumber_AfterUpdate()
    insert Me.Text11 = Me.IssuerID
    You can hide one of these two text boxes.
    It will save a new record.
    Did it slightly different but got the right outcome!
    Had the IssuerID pull txt box pull from txtbox that referenced the prior form. Works like a charm!

    Thanks for th ehelp.

Posting Permissions

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