Access databases and VB

Moderators: Gogi
Number of threads: 762
Number of posts: 1591

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
filter data on a form Posted by jh1460 on 2 Mar 2010 at 11:43 AM
I need to open a form with criteria. If I use the wizard I get the following code
stDocName = "frmCrisisLog"
stLinkCriteria = "lngCaseID = 1305384"
DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria


when I use this code the form opens and the status line indicates that the records are filtered however, the record (data) is not based on the criterion as above.

AND

the record toolbar indicates a filter is applied but a blank record is displayed i.e. not data... empty fields/ controls

when I poke the filter button all records are shown and data is displayed for the 1st record

when I poke the filter button a second time the correct record is displayed i.e. based on the criterion/ filter

what am I missing?? any help would be appreciated.

/jh



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.