Subform problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JennBard1 - 30 Sep 2005 15:57 GMT

I created a database to track our orders. I have a order detail form (&
table) and a purchase order form (& table). I have the order detail form as a
sub form on the purchase order table.
The order detail table has a product combo box in it, now when i am in the
purchase order form and try to select the product it tells me that i can't
assign a value to this object. It says - 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.
now i know its not the second object i assume its the forst so how do i fix
this problem?

Reply to this Message

'69 Camaro - 30 Sep 2005 19:56 GMT

Hi.

> The order detail table has a product combo box in it

This is known as a "lookup field." This appears to be very convenient, but
it will cause you all kinds of grief. For more information, please see the
following Web page:

http://www.mvps.org/access/lookupfields.htm

> now i know its not the second object

It may very well be, because this is the error one would expect to receive
with a lookup field. For a lookup field, what is displayed is not what is
stored. So your combo box selection may be attempting to store a text string
in a numerical field.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

> I created a database to track our orders. I have a order detail form (&
> table) and a purchase order form (& table). I have the order detail form as a
[quoted text clipped - 10 lines]
> now i know its not the second object i assume its the forst so how do i fix
> this problem?

Reply to this Message