Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 04-17-2018, 07:58 AM   #1
Newly Registered User
Join Date: Aug 2016
Posts: 45
Thanks: 31
Thanked 2 Times in 2 Posts
terrytek is on a distinguished road
Combo box issue

I have a field on a form that I needed to make a combo box instead of a text box because of data entry irregularities.

I followed this procedure to make the combo box, since the Combo Box Wizard doesn't seem to be working:

The records already in the underlying table have a value in this field.

The problem is, the new combo box works fine for making new records, but does not display the existing value for the records that are already in the database. How can I get that box to display the existing values from the underlying table?

Thank you!

Fumbling through with Access 2007; thank you to everyone here who is helping me learn
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
terrytek is offline   Reply With Quote
Old 04-17-2018, 08:33 AM   #2
bob fitz
Newly Registered User
Join Date: May 2011
Location: Essex England
Posts: 3,378
Thanks: 27
Thanked 650 Times in 635 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: Combo box issue

Have you set the Control Source property of the combo box to the correct field
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.

I have never failed. I have found a thousand ways that do not work!
bob fitz is online now   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box Issue Niranjeen Forms 5 05-05-2015 09:38 PM
Combo box issue mayusri Forms 3 11-14-2007 09:34 PM
Combo box issue kryten Forms 3 10-30-2006 12:47 PM
Combo Box Issue Graybeard Forms 0 08-18-2004 12:48 PM
Combo Box Issue jenvandiver Forms 6 01-10-2003 06:33 AM

All times are GMT -8. The time now is 05:51 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World