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 February 2nd, 2004, 11:52 PM
Registered User
Join Date: Dec 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Find Record Combo Box Wizard Won't Show 3rd Choice

Hi All,

Pretty much everyone knows that a very good way to find a record in a form is to use the combo box wizard and use the third choice - "Find a record on my form based on the value I selected in my combo box" on an unbound control.

Anyone know why that 3rd choice sometimes doesn't appear?

In my case, I have and ADP with a form with a record source table that was heavily modified. I fixed up the form and it works fine, but when I create an unbound control combo box, the wizard's 3rd choice is missing. If I recreate the form exactly, and create the combo box in the new form, it works fine. But the two forms, as far as I can tell, are exactly the same. They both have the same table as the record source, they both have the exact same fields, they even look the same. The only difference, as far as I can tell, is that the combo box wizard in the first one has only two choices and in the second one has three choices. Anyone know why?

Thanks much.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box Show all bound columns Coby Excel VBA 2 October 22nd, 2007 02:24 PM
Different subforms depending on combo box choice stevensj5 Access 5 October 3rd, 2007 08:54 PM
Combo box choice creating filtered combo box stevensj5 Access 11 September 13th, 2007 11:33 AM
Show all values in a combo box in a report Odeh Naber Access 3 July 24th, 2007 07:37 AM
Find Record Use Combo Box martinaccess Access 2 October 17th, 2004 07:42 AM

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