|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hi, I copied this from a sample database. I am making a menu form for the user to decide if he wants to start a new record, edit an old one, or run a report. This is supposed to start a new record, and it works in the sample database, but when I click it in mine, nothing happens. Any suggestions? Thanks!
In the On Click event of the control on the form I have: Menu_Items Macros.NewStudent : On Click
In the macro group Menu_Items Macros, in the macro NewStudent I have: GoToRecord Object Type = Form Object Name = Students (the table and form name) Record = New
|
|
in the OnClick event of the control on the form, select the macro name from the droplist *and do NOT add anything to the name*. i'm guessing the the actual name of your macro is NewStudent, not NewStudent : On Click.
hth
"Mommio2" <mommio2[ at ]insightbb.com> wrote in message news:uK9pb34sGHA.4596[ at ]TK2MSFTNGP04.phx.gbl...
[Quoted Text] > Hi, > I copied this from a sample database. I am making a menu form for
the > user to decide if he wants to start a new record, edit an old one, or run a > report. This is supposed to start a new record, and it works in the sample > database, but when I click it in mine, nothing happens. Any suggestions? > Thanks! > > In the On Click event of the control on the form I have: > Menu_Items Macros.NewStudent : On Click > > In the macro group Menu_Items Macros, in the macro NewStudent I have: > GoToRecord > Object Type = Form > Object Name = Students (the table and form name) > Record = New > >
|
|
Thanks for your reply! Ok, the plot thickens ... I tried removing ": On Click:" It was also listed in the macro under Macro Name with the ": On Click" included, so I deleted it there, too. Now, both the form control and the macro name are "NewStudent". When I go to form view and click on the control, nothing happens. Do I need to tell it anywhere else that the form "Students" is a different form from the one my control is on, which is called "Menu"?
"tina" <nospam[ at ]address.com> wrote in message news:PEXyg.505931$Fs1.12849[ at ]bgtnsc05-news.ops.worldnet.att.net...
[Quoted Text] > in the OnClick event of the control on the form, select the macro name > from > the droplist *and do NOT add anything to the name*. i'm guessing the the > actual name of your macro is NewStudent, not NewStudent : On Click. > > hth > > > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message > news:uK9pb34sGHA.4596[ at ]TK2MSFTNGP04.phx.gbl... >> Hi, >> I copied this from a sample database. I am making a menu form for > the >> user to decide if he wants to start a new record, edit an old one, or run > a >> report. This is supposed to start a new record, and it works in the > sample >> database, but when I click it in mine, nothing happens. Any suggestions? >> Thanks! >> >> In the On Click event of the control on the form I have: >> Menu_Items Macros.NewStudent : On Click >> >> In the macro group Menu_Items Macros, in the macro NewStudent I have: >> GoToRecord >> Object Type = Form >> Object Name = Students (the table and form name) >> Record = New >> >> > >
|
|
Wait a minute! Something is happening! I see now that (both ways) it does move the record counter at the bottom to the 13th (1st blank) record. It just leaves all the information from the first record on the form. What do I need to do to tell it to blank out the form, too? Thanks!
"tina" <nospam[ at ]address.com> wrote in message news:PEXyg.505931$Fs1.12849[ at ]bgtnsc05-news.ops.worldnet.att.net...
[Quoted Text] > in the OnClick event of the control on the form, select the macro name > from > the droplist *and do NOT add anything to the name*. i'm guessing the the > actual name of your macro is NewStudent, not NewStudent : On Click. > > hth > > > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message > news:uK9pb34sGHA.4596[ at ]TK2MSFTNGP04.phx.gbl... >> Hi, >> I copied this from a sample database. I am making a menu form for > the >> user to decide if he wants to start a new record, edit an old one, or run > a >> report. This is supposed to start a new record, and it works in the > sample >> database, but when I click it in mine, nothing happens. Any suggestions? >> Thanks! >> >> In the On Click event of the control on the form I have: >> Menu_Items Macros.NewStudent : On Click >> >> In the macro group Menu_Items Macros, in the macro NewStudent I have: >> GoToRecord >> Object Type = Form >> Object Name = Students (the table and form name) >> Record = New >> >> > >
|
|
is the DefaultView property of your form set the Single Form, Continuous Forms, or Datasheet?
hth
"Mommio2" <mommio2[ at ]insightbb.com> wrote in message news:%23ksCw19sGHA.3264[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text] > Wait a minute! Something is happening! I see now that (both ways) it
does > move the record counter at the bottom to the 13th (1st blank) record. It > just leaves all the information from the first record on the form. What do > I need to do to tell it to blank out the form, too? Thanks! > > > "tina" <nospam[ at ]address.com> wrote in message > news:PEXyg.505931$Fs1.12849[ at ]bgtnsc05-news.ops.worldnet.att.net... > > in the OnClick event of the control on the form, select the macro name > > from > > the droplist *and do NOT add anything to the name*. i'm guessing the the > > actual name of your macro is NewStudent, not NewStudent : On Click. > > > > hth > > > > > > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message > > news:uK9pb34sGHA.4596[ at ]TK2MSFTNGP04.phx.gbl... > >> Hi, > >> I copied this from a sample database. I am making a menu form for > > the > >> user to decide if he wants to start a new record, edit an old one, or run > > a > >> report. This is supposed to start a new record, and it works in the > > sample > >> database, but when I click it in mine, nothing happens. Any suggestions? > >> Thanks! > >> > >> In the On Click event of the control on the form I have: > >> Menu_Items Macros.NewStudent : On Click > >> > >> In the macro group Menu_Items Macros, in the macro NewStudent I have: > >> GoToRecord > >> Object Type = Form > >> Object Name = Students (the table and form name) > >> Record = New > >> > >> > > > > > >
|
|
It is Single Form. Is that my problem?
"tina" <nospam[ at ]address.com> wrote in message news:7w7zg.195130$mF2.86496[ at ]bgtnsc04-news.ops.worldnet.att.net...
[Quoted Text] > is the DefaultView property of your form set the Single Form, Continuous > Forms, or Datasheet? > > hth > > > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message > news:%23ksCw19sGHA.3264[ at ]TK2MSFTNGP03.phx.gbl... >> Wait a minute! Something is happening! I see now that (both ways) it > does >> move the record counter at the bottom to the 13th (1st blank) record. It >> just leaves all the information from the first record on the form. What > do >> I need to do to tell it to blank out the form, too? Thanks! >> >> >> "tina" <nospam[ at ]address.com> wrote in message >> news:PEXyg.505931$Fs1.12849[ at ]bgtnsc05-news.ops.worldnet.att.net... >> > in the OnClick event of the control on the form, select the macro name >> > from >> > the droplist *and do NOT add anything to the name*. i'm guessing the >> > the >> > actual name of your macro is NewStudent, not NewStudent : On Click. >> > >> > hth >> > >> > >> > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message >> > news:uK9pb34sGHA.4596[ at ]TK2MSFTNGP04.phx.gbl... >> >> Hi, >> >> I copied this from a sample database. I am making a menu form >> >> for >> > the >> >> user to decide if he wants to start a new record, edit an old one, or > run >> > a >> >> report. This is supposed to start a new record, and it works in the >> > sample >> >> database, but when I click it in mine, nothing happens. Any > suggestions? >> >> Thanks! >> >> >> >> In the On Click event of the control on the form I have: >> >> Menu_Items Macros.NewStudent : On Click >> >> >> >> In the macro group Menu_Items Macros, in the macro NewStudent I have: >> >> GoToRecord >> >> Object Type = Form >> >> Object Name = Students (the table and form name) >> >> Record = New >> >> >> >> >> > >> > >> >> > >
|
|
Yippee! That was it! Should I also change that property on the form I went to (in addition to the form I came from)? Also, how do I switch the focus from the first form to the second, i.e. make the second form pop on top of the other? THANKS!!!
"tina" <nospam[ at ]address.com> wrote in message news:7w7zg.195130$mF2.86496[ at ]bgtnsc04-news.ops.worldnet.att.net...
[Quoted Text] > is the DefaultView property of your form set the Single Form, Continuous > Forms, or Datasheet? > > hth > > > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message > news:%23ksCw19sGHA.3264[ at ]TK2MSFTNGP03.phx.gbl... >> Wait a minute! Something is happening! I see now that (both ways) it > does >> move the record counter at the bottom to the 13th (1st blank) record. It >> just leaves all the information from the first record on the form. What > do >> I need to do to tell it to blank out the form, too? Thanks! >> >> >> "tina" <nospam[ at ]address.com> wrote in message >> news:PEXyg.505931$Fs1.12849[ at ]bgtnsc05-news.ops.worldnet.att.net... >> > in the OnClick event of the control on the form, select the macro name >> > from >> > the droplist *and do NOT add anything to the name*. i'm guessing the >> > the >> > actual name of your macro is NewStudent, not NewStudent : On Click. >> > >> > hth >> > >> > >> > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message >> > news:uK9pb34sGHA.4596[ at ]TK2MSFTNGP04.phx.gbl... >> >> Hi, >> >> I copied this from a sample database. I am making a menu form >> >> for >> > the >> >> user to decide if he wants to start a new record, edit an old one, or > run >> > a >> >> report. This is supposed to start a new record, and it works in the >> > sample >> >> database, but when I click it in mine, nothing happens. Any > suggestions? >> >> Thanks! >> >> >> >> In the On Click event of the control on the form I have: >> >> Menu_Items Macros.NewStudent : On Click >> >> >> >> In the macro group Menu_Items Macros, in the macro NewStudent I have: >> >> GoToRecord >> >> Object Type = Form >> >> Object Name = Students (the table and form name) >> >> Record = New >> >> >> >> >> > >> > >> >> > >
|
|
to move the focus to another form, try using the SelectObject action in your macro.
hth
"Mommio2" <mommio2[ at ]insightbb.com> wrote in message news:%238s3JbCtGHA.1296[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text] > Yippee! That was it! Should I also change that property on the form I
went > to (in addition to the form I came from)? Also, how do I switch the focus > from the first form to the second, i.e. make the second form pop on top of > the other? THANKS!!! > > > "tina" <nospam[ at ]address.com> wrote in message > news:7w7zg.195130$mF2.86496[ at ]bgtnsc04-news.ops.worldnet.att.net... > > is the DefaultView property of your form set the Single Form, Continuous > > Forms, or Datasheet? > > > > hth > > > > > > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message > > news:%23ksCw19sGHA.3264[ at ]TK2MSFTNGP03.phx.gbl... > >> Wait a minute! Something is happening! I see now that (both ways) it > > does > >> move the record counter at the bottom to the 13th (1st blank) record. It > >> just leaves all the information from the first record on the form. What > > do > >> I need to do to tell it to blank out the form, too? Thanks! > >> > >> > >> "tina" <nospam[ at ]address.com> wrote in message > >> news:PEXyg.505931$Fs1.12849[ at ]bgtnsc05-news.ops.worldnet.att.net... > >> > in the OnClick event of the control on the form, select the macro name > >> > from > >> > the droplist *and do NOT add anything to the name*. i'm guessing the > >> > the > >> > actual name of your macro is NewStudent, not NewStudent : On Click. > >> > > >> > hth > >> > > >> > > >> > "Mommio2" <mommio2[ at ]insightbb.com> wrote in message > >> > news:uK9pb34sGHA.4596[ at ]TK2MSFTNGP04.phx.gbl... > >> >> Hi, > >> >> I copied this from a sample database. I am making a menu form > >> >> for > >> > the > >> >> user to decide if he wants to start a new record, edit an old one, or > > run > >> > a > >> >> report. This is supposed to start a new record, and it works in the > >> > sample > >> >> database, but when I click it in mine, nothing happens. Any > > suggestions? > >> >> Thanks! > >> >> > >> >> In the On Click event of the control on the form I have: > >> >> Menu_Items Macros.NewStudent : On Click > >> >> > >> >> In the macro group Menu_Items Macros, in the macro NewStudent I have: > >> >> GoToRecord > >> >> Object Type = Form > >> >> Object Name = Students (the table and form name) > >> >> Record = New > >> >> > >> >> > >> > > >> > > >> > >> > > > > > >
|
|
|