[AccessD] @#$%^&* bound forms - can' edit field, bound to unkown field

Rocky,
 
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.
 
Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Friday 2003 May 09 10:55
To: AccessD at databaseadvisors.com
Subject: [AccessD] @#$%^&* bound forms - can' edit field, bound to
unkown field

 
 Dear List:
 
There's something simple going wrong here, but I can't spot it. 
 
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.  
 
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.
 
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.)
 
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?
 
MTIA,
 
Rocky Smolin
Beach Access Software
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030509/6c42ca3e/attachment-0001.html>