	AllExperts > Using MS Access
	Search

About Bob Heifler
Expertise

ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS
Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here.

Experience
Microsoft Access programming since 1994. Support for all versions.

Publications
My Microsoft Access articles are published at:DailyAccessTips.com

Education/Credentials
UCLA GRAD, Member of Association of Database Developers

Awards and Honors
AccessToExcel.com has won several shareware awards for assisting analysts in moving data from MS Access to Excel.

Past/Present Clients
See some of my past clients here.

You are here: Experts > Computing/Technology > Business Software > Using MS Access > Save value unbound textbox

Using MS Access - Save value unbound textbox

Expert: Bob Heifler - 10/28/2009

Question
hello there,

I have a question concerning an unbound textbox. The controlsource of the textbox is the following: =Categorypub.Column(2) , as it refers back to a combobox. However, I would like to save this value into my table in the field ´budgetcategory´. I do not seem to be able to do this, as the controlsource is already populated. Can you help me out?
Thanks!

Answer
Sophie,
On the AfterUpdate event of the combobox called "Categorypub", place this line of code:

budgetcategory = Categorypub.Column(2)

Glad to help,
Bob Heifler

MyAccessProgram.com
DailyAccessTips.com

Contact at:
http://myaccessprogram.com/Contact.html

Find example files at:
http://myaccessprogram.com/Download.html

Find free video tutorials at:
http://myaccessprogram.com/Tutorial.html

Ask a Question