Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Close Find screen when match is found

Status
Not open for further replies.

mauricionava

Programmer
Jul 8, 2005
209
US
Hello,
My form has 3 or 4 Find buttons created with the button wizard and I would like the Find/Search screen to close when the match is found. Is there a way to do this?

Thanks.
 
Perhaps something like this:
Re.FindFirst "ID = " & Me!YrID
If Not Re.NoMatch Then
Forms!YrForm.Bookmark = Re.Bookmark
DoCmd.Close AcForm, "YrSearchForm"
end if

If this solves the problem, fine - if not let us have a look at your code, so we perhaps can see where the snag is.

Herman
Say no to macros
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top