"Not a valid bookmark" error with recently-linked table

Follow

Kelley Freeman

• October 10, 2019 14:48

Can anyone advise on this weird problem:

On a form i have a combo box that lets the user select a data file

If the user enters a not-in-list value in the combo box:

       a new table on the backend is created

       a link to the new table is established

MY PROBLEM:  In subsequent code,  "If DCount("[fldPatientID]", Me.txtDataSet) "  produces "Not a valid bookmark" error (where "txtDataSet" is the newly linked table) 

BUT, if I re-select the new table in the combo box on the form, that same line of code executes without error

Any advice would be greatly appreciated...

--Kelley Freeman

 

0

• 

  Rachel Gomez

  • December 28, 2022 05:54

  All you need to do is to replace the damaged file with a copy of the backup database. Sometimes, the backup file might be damaged, deleted, or non-existent.

   

  Regards,

  Rachel Gomez

  0

  Comment actions Permalink

Please sign in to leave a comment.