Solved

Requery not working

Posted on 2011-03-04
3
349 Views
Last Modified: 2012-05-11
See attached form AAForm.

Click the red button to requery.
It crashes !  WHAT's Wrong with my code??
How do I requery (and refresh) forms AAA and AAB (which are in the form AAForm)??
Database3.zip
0
Comment
Question by:Patrick O'Dea
  • 2
3 Comments
 
LVL 75
ID: 35040789
Try the attached

mx
Database3-mx01.zip
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 35040795
Basically change

Form!AAA.Form.Requery

to
Me.AAA.Form.Requery

same for the other line.

mx
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 35040839
Thanks DatabaseMX

That works well.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question