<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=538000216-09052003><FONT color=#0000ff
size=2>Rocky,</FONT></SPAN></DIV>
<DIV><SPAN class=538000216-09052003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=538000216-09052003><FONT color=#0000ff size=2>A bound combo box
has a Row Source Type which should be "Table/Query" and a Row Source which
should be the name of either a table or a query. Then the Control Source
should be the name of a field from the Row Source, not from the form's data
source.</FONT></SPAN></DIV>
<DIV><SPAN lang=en-us><B><FONT color=#0000ff></FONT></B></SPAN> </DIV>
<DIV><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rocky Smolin - Beach Access
Software [mailto:bchacc@san.rr.com] <BR><B>Sent:</B> Friday 2003 May 09
10:55<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
@#$%^&* bound forms - can' edit field, bound to unkown
field<BR></FONT></DIV>
<DIV><FONT size=2><SPAN class=538000216-09052003><FONT
color=#0000ff> </FONT></SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=538000216-09052003> </SPAN>Dear
List:</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>There's something simple going wrong here, but I can't spot
it. </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I have a combo box which is bound to a field
'fldRAHPaymentTermsID'. The data source of the form is
'qryRentalAgreementHeaderByOrderNumber' which has 'fldRAHPaymentTermsID' as one
of its fields. And the field shows up in the Control Source of the combo
box. </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>The combo box has tblPaymentTerms as its row source - a table
with two fields - a payment term ID and the payment term description. Bound
column is 1.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>When I try to select a value form the combo box it I get a
message in the status line; "Control can't be edited; it's bound to unknown
field 'fldRAHPaymentTermsID'. If I try to set the combo box value in code
I get and error "You can't assign a value to this object". (Of course not, it's
bound to an unknown field.)</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>If I open the query, I can insert a value in the
'fldRAHPaymentTermsID' field in the table view of the query. So it's got
to be something in the form, Yes?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>MTIA,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Rocky Smolin<BR>Beach Access Software</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV></BODY></HTML>