smercer
Registered User.
- Local time
- Tomorrow, 02:57
- Joined
- Jun 14, 2004
- Messages
- 442
Hi all
I am trying to make a entry form where if the user starts typing in a record that already exists, it will open a popup form that will ask if the user was entering this record.
The problem with this is, when it appears it takes the focus. What I want it to do is appear and the form currently being typed in to still have the focus.
The reason is the user does not want to take his hands off the keyboard to use the mouse to click in the right field in the right form if the suggested record was not what he was entering.
How this all works is the user starts typing in the title and because it is a combo box he is typing in, it gets automaticly filled in (but can still type the title). when he leaves the field, It runs a dlookup and if there is a matching title then a popup form will appear (which is based on a query).
Because this is for a second hand book store, the ISBN number is not a choice to use for testing for unquie books, because each reprint gets a new ISBN number.
Does anyone have any ideas?
Thanks in advance
I am trying to make a entry form where if the user starts typing in a record that already exists, it will open a popup form that will ask if the user was entering this record.
The problem with this is, when it appears it takes the focus. What I want it to do is appear and the form currently being typed in to still have the focus.
The reason is the user does not want to take his hands off the keyboard to use the mouse to click in the right field in the right form if the suggested record was not what he was entering.
How this all works is the user starts typing in the title and because it is a combo box he is typing in, it gets automaticly filled in (but can still type the title). when he leaves the field, It runs a dlookup and if there is a matching title then a popup form will appear (which is based on a query).
Because this is for a second hand book store, the ISBN number is not a choice to use for testing for unquie books, because each reprint gets a new ISBN number.
Does anyone have any ideas?
Thanks in advance
