You are here:

Using MS Access/Fill a text box based on combo box value


Chris wrote at 2008-04-21 20:19:03
Is there some limitation when setting the text box equal to the combo box?

I can't seem to get any data from column 2 in my query.  

When I try the following no value shows up in my text box.  I know there is data from the query and I verified the name of the field on the form.

Me.Case_LName = Me.CaseNumber.Column(2)

Matt wrote at 2010-02-08 01:22:33
Julie, I scoured the web looking for the answer to this same question.  Thanks for a clear, concise answer!!! You are awesome.

KarieFairie wrote at 2012-10-30 19:21:11

I'm having the same problem as Chris did, regarding assigning the second, third, and forth columns to text boxes.  No errors, just won't do it.  Was this second question answered.

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Julie Misson


My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past twelve years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.


I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the website.

Self taught in Microsoft Access. Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.

©2017 All rights reserved.