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 August 12th, 2003, 09:49 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default Combox not showing data when criteria is changed

I have a continuous subform that has a combobox in the detail that shows TOOLS, in the subform Header I have a combobox called TOOL_TYPE.

I have the user select the TOOL_TYPE which is used to filter the query in TOOLS. This works fine, but my problem is how do I show the data in all the records that have allready been selected when they don't match the criteria in TOOL_TYPE ?

For example: the previously selected entries might be one of each: Taps, Inserts, Counter Sinks. If on the new record they select TOOL_TYPE = Drills then all the comboboxs for the previous records go blank because they are not Drills.

Right now the only thing I can think of is putting a field on top of the combox that actually does a DLOOKUP.

Any better solutions?
__________________
Mitch
 
Old September 10th, 2004, 09:19 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi!
If u use the filter as a data entry form, use an edit form to see all records
after the update.
Regards Penta.

 
Old September 10th, 2004, 11:54 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post
Default

Mitch,
Try the suggestion I gave Chantal with similar problem.
John






Similar Threads
Thread Thread Starter Forum Replies Last Post
Runtime Error 7878 Data has been Changed ayazhoda Access VBA 0 May 22nd, 2008 09:08 AM
DetailsView: chk 4 changed data before modechange? ledneh ASP.NET 2.0 Basics 0 December 18th, 2007 07:00 PM
track page data has changed webmahesh XSLT 1 December 12th, 2007 06:54 PM
How to check whether page data has changed webmahesh JSP Basics 0 December 12th, 2007 04:38 AM
Data has changed error with linked ODBC table Wim Leys Access 7 June 8th, 2004 06:05 AM





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