Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-27-2006, 10:34 AM   #1
froggiebeckie
Newly Registered User
 
Join Date: Oct 2002
Location: Virginia
Posts: 104
Thanks: 15
Thanked 2 Times in 2 Posts
froggiebeckie
Can't assign a value to this object

Greetings, all.
Run into a snag with a payroll db, appreciate any help you can give me.

Main Form, with ordinary payroll/personnel info--clock no, first and last names, S.S.no., etc.
Subform for entering regular hours worked, OT hours worked, etc per Period Ending, keyed to main form by SS no. Pretty basic stuff.

Problem is, when we try to enter the first data in the subform, we get this error message :
"You can't assign a value to this object.
*The object may be a control on a read-only form.
*The object may be on a form that is open in Design view.
*The value may be too large for this field."


We get the message in the first field we go to, no matter which field we go to first.
None of the "may be" conditions apply.

When we hit "OK" the message goes away and we can enter our data, the records are created corrected. But as soon as we move to the next record, we get the same error.

Any idea why we're getting this error message?

Thanks for looking,
BeckieO

froggiebeckie is offline   Reply With Quote
Old 03-27-2006, 11:56 AM   #2
froggiebeckie
Newly Registered User
 
Join Date: Oct 2002
Location: Virginia
Posts: 104
Thanks: 15
Thanked 2 Times in 2 Posts
froggiebeckie
Never Mind

Sorry, turns out the SS no field in the subform had a calculated value, instead of a link.
Not sure how that happened, but that was the problem.

Thanks to all, anyway,
BeckieO
froggiebeckie is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't assign value to an object BobMcL Forms 1 03-19-2006 08:59 PM
You cant assign a value to this object?? desibasha General 0 04-08-2004 02:02 PM
You can't assign a value to this object kholm Forms 1 10-30-2002 12:31 PM
I cannot assign a value to a control object arage Modules & VBA 4 06-04-2001 10:40 AM
Can't assign value to this object ERROR lmangano Forms 2 12-20-2000 09:39 AM




All times are GMT -8. The time now is 03:25 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World