ajetrumpet
Banned
- Local time
- Today, 06:17
- Joined
- Jun 22, 2007
- Messages
- 5,638
folks,
I have a bound field on a form with a dynamic recordsource. when i push a button, i am populating a variable from that bound field. the code is erroring out on me on this line:
the variable is a double in my declarations moduel, and the bound field from the table is a LONG. it is giving me a runtime error 3164, field cannot be updated. here is the recordsource for the form:
can anyone help me out here?
I have a bound field on a form with a dynamic recordsource. when i push a button, i am populating a variable from that bound field. the code is erroring out on me on this line:
Code:
CurrentUser = Me.userIDnum
Code:
SELECT TherapyDefaults.*, CurrentUser.CurrentUser
FROM TherapyDefaults INNER JOIN CurrentUser ON
TherapyDefaults.userIDnum=CurrentUser.CurrentUser WHERE
(((CurrentUser.CurrentUser)=CurrentUser!CurrentUser));