Parasyke wrote:
Please help.... I have a form that I successfully add records to that I
want to copy and turn into a form for editing records from that same
table (It is imperitive that it be done this way, rather than just one
form) ... I need in the textbox for the new edit form to have the user
type in a item# then the form populates. I'm having tremedous trouble
with the logic of this.
Thanks!!! Dav
The easiest, quickest way is to create a copy of your existing form.
Set the Allow Deletions and Allow Additions property of the form to No.
Tell your users to click in the item number field and then press
Ctrl-F and then instruct them how to use the Find dialog. You can
expand on this by creating a 'Find' command button on your form (you
can even use the command button wizard to create this for you). You
could expand on this further by 'locking' the find button to search
only a specific field by making it set focus to the field on the form
you're searching by by putting code like the following in its Click
event:
ItemNumber.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Bruce