I have a database application I'm developing that is used to track RMA
data for my employer. From the main RMA form I have added a button
allowing a search of ALL records, not just the ones for the customer
currently being displayed. A quick screenshot of the form arrangment
has been uploaded to the Files section, and is called "screenshot.jpg".
When the appropriate button is clicked, the "Search All" form pops up
with two empty combo boxes. The first allows you to select which data
field to search in, and once that selection is made the second combo
box then shows all available possibilities for the field chosen. At
that point the user will click the "Begin Search" button and the
search form's subform should then display all matching records.
When the "Begin Search" button is clicked a temporary storage table is
purged and then refilled with all matching records. However, here's
the problem... the subform will not refresh to show the matching
records until I either click the button a second time, or close and
reopen the form!
I have tried everything I can think of to make the subform "refresh"
to show the current set of results instead of the previous set, but it
refuses to do so. Any ideas on this?
Sorry for the length of the post, but I figured if I give enough
information the first time it will lessen confusion over what I'm
trying to do!
Thanks in advance for any help you guys/gals may be able to provide!
Bill R.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
