Prev: Problem with closing from from Close Button
Next: Need help with programming again
From: WendyK on 14 Apr 2010 13:40
Hello All

I am trying to link a series of forms in a simple student database and I am
a newbie to this stuff. I would like to be able to insert a button on the
form for biographical information that then saves and opens a program
information form and so on. This would not be a very large database (n<100).
I cannot find anything online that will show me a sample macro coding for
this type of button. Help is greatly appreciated.

Wendy
From: Marshall Barton on 14 Apr 2010 14:25
WendyK wrote:
>I am trying to link a series of forms in a simple student database and I am
>a newbie to this stuff. I would like to be able to insert a button on the
>form for biographical information that then saves and opens a program
>information form and so on. This would not be a very large database (n<100).
> I cannot find anything online that will show me a sample macro coding for
>this type of button.

The VBA code in the button's Click event procedure could
look like:

If Me.Dirty Then Me.Dirty = False ' save current record
DoCmd.OpenForm "nextform"

For several reasons, I don't use macros, but I'll bet that
the equivalent actions can be done.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Problem with closing from from Close Button
Next: Need help with programming again