Art,
It looks like RandomID is text and you are treating it like it's numeric. Try change the macro line to:
="[RandomID]='" & Nz([RandomID],0) & "'"
This needs to be done for both Open and Random ID columns.
BTW: have you considered normalizing your database?
Duane Hookom MVP
MS Access
----------------------------------------
> From: dbalorenzini@yahoo.com
>
> I am uploading by database because when I open my Survey List form and then click to 'Open' to open a record I get a Data Type Mismatch error. I rechecked all the tables and the PK in all the tables are all Short text. Fairly confused.
>
> Thanks
>
> Art Lorenzini
> Sioux Falls,SD
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar