How to use requery

[jmeehan]

I created a Form that has a sub-form. I then created another sub-form based on the first sub-form. In order to make the second sub-form update when selecting a record on the first sub-form I used a requery in the current event of the first sub-form. This does the trick. My problem is that once someone does 3-4 "Find"s on the main form the form freaks out and sometimes crashes Access. Does anyone know what is causing this to happen and how can I fix the problem?

Thanks for the help in advance.

James R. Meehan
Information Systems Specialist
Public Citizen
215 Pennsylvania Ave SE
Washington, DC 20003-1155
202.546.4996 -- Work

http://www.citizen.org

jmeehan@citizen.org

 

[downwitchyobadself]

Make sure if you're using multiple linked subforms that your "Perform name AutoCorrect" option is turned off (Tools > Options > General tab).

You might also consider replacing that second subform with a list box or combo box and some editable controls? This article from MS

http://support.microsoft.com/support/kb/articles/Q209/1/13.ASP

describes some other ways to optimize subforms.