Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    LA, CA
    Posts
    54

    Question Unanswered: Run query on a new record creation?

    Hi you brilliant access folk!

    Ok... so, i have this lovely autonumber field which assigns Bid Numbers to new bids.

    When a new bid is started, i want to run an append query. I am not even sure what event to use on the form... is it On Dirty?

    any thoughts???

    Thanks kindly

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Presuming you use the form for editing as well as adding new records, I'd lean towards the after insert event. The dirty event will fire for an edited record, which presumably you wouldn't want to run this query for. The dirty (and before insert) event fires with the first keystroke, so you'd run the risk that the user might escape out and not save the record. The after insert event would only fire if they saved the record.
    Paul

  3. #3
    Join Date
    Nov 2003
    Location
    LA, CA
    Posts
    54
    PERFECTION! You rule, Paul

    thank you so much

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No problem Rachel.
    Paul

Posting Permissions

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