By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Urgent, Convert "Add Form" to "Edit Form

P: n/a
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

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


P: n/a

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

Oct 26 '06 #2

P: n/a
On Oct 26, 11:53 am, "Parasyke" <kress1963no...@yahoo.comwrote:
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)
Please, add to our knowledge by explaining why it is imperative that it
be done this way.

Oct 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.