Access a button from anther form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ac - 29 Jan 2008 22:36 GMT

Hi,

I have two forms which are View and Edit. The first form displays all
records in a table and second uses to edit record which includes Add, Save
and Delete buttons. If user does not find the record on the View form, he has
to add the new record on the Edit form. Now, switch forms will take time if
there are lots of records to add. I would like to create a button on the View
form called New, When user clicks on the New button, the new record form
with the current record number will be displayed, (just like the user clicks
on Edit form/Add button. How can I write code for New button? Thanks

Reply to this Message

Abs - 29 Jan 2008 22:31 GMT

Ineed help with my loptop there is many thing i dont understand

> Hi,
>
[quoted text clipped - 10 lines]
> clicks
> on Edit form/Add button. How can I write code for New button? Thanks

Reply to this Message

DanRoss - 30 Jan 2008 00:50 GMT

If you have a form that work for edits - use that form

in the New Button onclick event

'add

DoCmd.OpenForm "YourEditForm", acAdd

Althoug - for a new Record there should be NO current recordnumber if there
is - then it's not really a new record just edit it.

> Hi,
>
[quoted text clipped - 10 lines]
> clicks
> on Edit form/Add button. How can I write code for New button? Thanks

Reply to this Message