Results 1 to 2 of 2

Thread: 3426, SQL and Data Controls query ...

  1. Jan 22nd, 2000, 11:50 AM #1
    Lil Dave
    Lil Dave is offline

    Thread Starter
    Junior Member
    Join Date
    Jan 2000
    Location
    Christchurch, New Zealand
    Posts
    19

    Post

    Okey dokey,

    clunietp was kind enough to respond last time I posted with this darn

    '3426 :Action was cancelled by an associated object' error

    He (and others) suggested not using a data control where the AddNew was causing the error.

    So I have rewritten the code to use a 'Append Query' and it works.

    Now how do I make the data control show the new record ?

    ... I have tried datOrders.Refresh ... no go
    ... I have tried setting the .Recordsource to "" and then refreshing, then resetting the .Recordsource property ... but thats no go either.

    How do you do it.

    Cheers Dave
    Reply With Quote Reply With Quote
  2. Jan 24th, 2000, 08:12 AM #2
    pardede
    pardede is offline
    Addicted Member pardede's Avatar
    Join Date
    Jan 2000
    Posts
    232

    Post

    have you tried using .movelast .movefirst to populate the recordset
    or go to your particular record using .findfirst or .bookmark=lastmodified?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width