<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>There's something simple going wrong here, but I
can't spot it. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 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 face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 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 face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 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 face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 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 face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access Software</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>