Subform problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi.
The order detail table has a product combo box in it
Click to expand...

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
Click to expand...

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.
 
Back
Top