A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

FindRecord Control Button



 
 
Thread Tools Display Modes
  #1  
Old January 30th, 2008, 05:48 PM posted to microsoft.public.access
Ryan
external usenet poster
 
Posts: 551
Default FindRecord Control Button

i built a find record control button so a user can type in the form number
and go there but it only searches the field that the cursor is in and the
form # is not on the tab order(purposely). How can i specify where the find
record function searches? thanks
  #2  
Old January 30th, 2008, 11:32 PM posted to microsoft.public.access
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default FindRecord Control Button

Ryan,
usually people use an unbound combo box or an unbound text box for
searching.
There is a sample download with code of a search form at
http://www.allenbrowne.com/ser-62.html
If you need help to get it working, post back.

You can also use the wizard to put a combo for searching on your form.
On the form in design view, click the combo box tool, the wizard will open,
choose the 3rd option Find a record on my form . . . .

Jeanette Cunningham

"Ryan" wrote in message
...
i built a find record control button so a user can type in the form number
and go there but it only searches the field that the cursor is in and the
form # is not on the tab order(purposely). How can i specify where the
find
record function searches? thanks



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.