ACC: How to Use a Bound Control to Find a Record (95/97) (136123)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q136123 Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
This article shows you how you can use a single, bound control for both
finding records and for entering data in a form. You can use this technique
to find whether the value entered in a field already exists in another
record. If the value does exist in another record, the record containing
that value is displayed. If the value does not exist in another record, you
can continue entering data for the current record.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
REFERENCES
For more information about this topic in Microsoft Access version 2.0,
please see the following article in the Microsoft Knowledge Base:
115189
ACC2: How to Find a Record Using a Bound Control
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming kbusage KB136123 |
---|
|