Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Toronto
    Posts
    11

    Unanswered: troubles with adding new record

    I'm trying to add a new record to a table by filling its fields from data coming from a form. When I used:
    DoCmd.GoToRecord , , "tblName", acNewRec

    it throws "type mismatch" error

    I then used DoCmd.RunCommand acCmdRecordsGoToNew instead, and then it's adding the new recod BUT THERE FEW FIELDS NOT COPIED TO THE TABLE. ( 2 texts and 2 dates)

    Please help! what could have happened.
    just to let you know I checked all fields types. they looked fine


    thanks

    badr

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Just for the heck of it....go into a code window, select the "Debug" menu item, then select "Compile and Save all Modules". If it does'nt indicate the problem then.....check your field types again.

  3. #3
    Join Date
    Dec 2003
    Location
    Toronto
    Posts
    11
    Originally posted by CyberLynx
    Just for the heck of it....go into a code window, select the "Debug" menu item, then select "Compile and Save all Modules". If it does'nt indicate the problem then.....check your field types again.
    I did compile all again, but still nothing...

Posting Permissions

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