	AllExperts > Using MS Access
	Search

About Scottgem
Expertise
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience
I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

You are here: Experts > Computing/Technology > Business Software > Using MS Access > Link - Table & Form

Using MS Access - Link - Table & Form

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

Add to this Answer Ask a Question