Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 11th, 2004, 11:52 AM
Registered User
 
Join Date: Oct 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2000 Text not refreshing in combo box

In the details of my main form, I have a 2 column combo box with the first column (hidden) bound to UnitID. When the form opens, the 2nd column, UnitDescription displays normally. In the OnEnter event of the combo box, I set its rowsource using a sql statement that creates a subset of items based on the contents of another field in the same row. Once I cause this event to fire in any row and then minimize the form or move another window over the top of any of the fields in that column, the text in the combo box(s) that was not visible is erased. If I force a refresh from code then all of the visible text in that column is gone. If I view the drop down list, all of the items I expect to see are there. If I select something from the list, then that item is correctly displayed and is not erased. Any ideas?

 
Old October 11th, 2004, 09:48 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

It is possible you may need to refresh the combo box
Try adding Requery to view the latest records in a combo box called UnitID, add the following method to the procedure: unitid.requery


Jaime E. Maccou
Applications Analyst





Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate a text box from a combo box value dnf999 Access VBA 7 February 6th, 2012 02:24 PM
Count in combo box(display results in text box) mboyisis Access 4 April 4th, 2008 07:08 AM
Combo box and Text box Rudner Access VBA 4 November 16th, 2004 02:57 PM
Combo Box and Text Box Rudner Beginning VB 6 1 November 8th, 2004 04:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.