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...
Please sign in to leave a comment.