Expert: Scottgem - 11/6/2009

Question
QUESTION: I created a update form for my table. In the form, I created a text box (client's name) which automatically show the record when I key in the combo box (client's ID). My problem is that the client's name did not reflect or updated in the table for new record I enter. The rest of the field; combo boxes, reflect/updated perfectly into the table.

ANSWER: Sounds like you created a "search" combo using the wizard. This creates an UNBOUND control so any changes to it are not reflected in the table. The answer is to add a BOUND control to your form, bound to the client name fields.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

---------- FOLLOW-UP ----------

QUESTION: I'm currently using MS Access 2003. How can I find a "bound" text box which it automatically display "unbound"? The only bound control that I can find is "Bound Object Frame"

Answer
A bound control is one where the ControlSource is set to a filed in the form's Recordsource. If, in design mode, the control says Unbound, then that tells you it is, in fact, unbound.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA