424,054 Members | 1,044 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,054 IT Pros & Developers. It's quick & easy.

Search field in search record dialog not same as focussed field

P: n/a
When I push on my find-record button, after I focussed on the ID-number
field on my form, the default search field in the Search-form dialog
menu is not the focussed field, but another.

Why?

Bart
Access 2003

Jun 1 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
AA Arens wrote:
When I push on my find-record button, after I focussed on the ID-number
field on my form, the default search field in the Search-form dialog
menu is not the focussed field, but another.

Why?

Bart
Access 2003

Perhaps you set focus to another field in the OnCurrent event or in
codes someother place. Try a search for the word "SetFocus" in your code.
Jun 1 '06 #2

P: n/a
It works, I put several buttons nrear the fields on my form.
This is the VB code (copied from a find record-button, placed via
wizzard)

Private Sub Command137_Click()
On Error GoTo Err_Find_Record_Click
Me.CompanyName.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Find_Record_Click:
Exit Sub
Err_Find_Record_Click:
MsgBox Err.Description
Resume Exit_Find_Record_Click
End Sub

I do have a minor issue: The Look In field of the find-record dialog
box is first set a the form name, not the field name as mentioned in
the code (SetFocus).
It happen only when I approached the form for the first time after I
start Access. Why?

Bart



salad wrote:
AA Arens wrote:
When I push on my find-record button, after I focussed on the ID-number
field on my form, the default search field in the Search-form dialog
menu is not the focussed field, but another.

Why?

Bart
Access 2003

Perhaps you set focus to another field in the OnCurrent event or in
codes someother place. Try a search for the word "SetFocus" in your code.


Jun 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.