Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 04-14-2006, 01:57 AM   #1
Rob Mc
Join Date: Jan 2006
Location: Leeds, West Yorkshire
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
BobMcL is on a distinguished road
Exclamation Can't assign value to object

I keep getting this message when I try and input a product ID in the subform in my 'Order Form', the message says 'you can't assign a value to this object' and when i try to click the row below it says 'You cannot add or change a record because a related record is required in table 'Invoices'', how can I change this? do i have to relate it to the Products table and if so how do i do this? Thanks, Bob.

System Link:
Gamez System

BobMcL is offline   Reply With Quote
Old 04-15-2006, 12:44 PM   #2
Registered User
alteque's Avatar
Join Date: Apr 2006
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
alteque is on a distinguished road
I could be totally wrong, but it sounds like your subform is linked to your main form and in order to start entering data into the subform you need to have a record to associate it to. Try entering data into the main form first and see if that helps any. Best of luck.

alteque is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't assign a value to this object froggiebeckie Forms 1 03-27-2006 11:56 AM
Can't assign value to an object BobMcL Forms 1 03-19-2006 08:59 PM
can't assign value to an object jeo Forms 1 01-13-2005 01:26 PM
You cant assign a value to this object?? desibasha General 0 04-08-2004 02:02 PM
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 05:34 AM.

Microsoft Access Help
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