Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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 December 2nd, 2004, 02:43 PM
Friend of Wrox
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Auto Filling Combo on Form

I have three forms each with two combo boxes that should be filled automatically from another combo on the same form.
Two forms run as it should but one i've been trying with no
result. This form that doesnt run differs from the others
because the source table of the combos have the plus column
that permits to see relational fields from a second table.
I suspect that this column should be deleted. I've been
running A2K2 and i dont know how to do it.
Any help would be welcome.
Regards Penta.
Old December 2nd, 2004, 04:33 PM
Friend of Wrox
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts

Are you using a table as a recordsource for the tables?

If so, what I have done in similar situations, is to bind both combo boxes to the same field in the table, so when one is changed, the other is updated automatically.

I am not sure if this will help or not. I haven't experimented as all with the 'plus column', so am pretty much clueless when it comes to that

Old December 3rd, 2004, 06:14 AM
Friend of Wrox
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts

Yes, i have tbs as sources. I will try ur way.
Thank u for ur care.
Trully P.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling a combo box w/in datagridview kscase Visual Basic 2005 Basics 1 July 12th, 2007 07:26 AM
Macro for Auto-filling a pre-made Word form dan_thorman Excel VBA 0 January 25th, 2007 10:46 AM
filling a combo box from a data object allee_man Beginning VB 6 1 March 1st, 2005 08:08 AM
filling a combo box using an array tware VB Databases Basics 0 September 21st, 2004 08:40 AM

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