My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Command Button
|
|
 Apr 10 2006, 11:53 AM
Post
#1
|
|
|
UtterAccess Ruler Posts: 1,187 From: MI, USA  |
When setting up the command button, it gives you the choice of either opeining the form and showing specific data or to show all records. Since I am putting this on my main form for the user to enter data, I should choose the second option?
|
 |
 
|
|
Apr 10 2006, 11:54 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
Yes, that would be the way to do it.
|
|
|
|
|
Apr 10 2006, 11:56 AM
Post
#3
|
|
|
UtterAccess VIP Posts: 9,209 From: Maryland |
It depends on what you want the button to do? If you want the user to be taken to a blank record you should put this code on your button:
DoCmd.OpenForm "frmFormName",,,,acFormAdd HTH. |
|
|
|
|
Apr 10 2006, 11:57 AM
Post
#4
|
|
|
UtterAccess Ruler Posts: 1,187 From: MI, USA |
Well, if I put that code on the button, can they also review posted records? If I just set it to them viewing all records, doesn't it take them to a blank record, also?
|
|
|
|
|
Apr 10 2006, 12:00 PM
Post
#5
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
If you do it as William advised, it will display the NEW RECORD only. They can enter many records but cannot see any that were existing when the form was opened. They can tho scroll thru those they have entered since opening the form.
If you do it my way, it will display existing records and allow enter of new ones. |
|
|
|
|
Apr 10 2006, 12:22 PM
Post
#6
|
|
|
UtterAccess Ruler Posts: 1,187 From: MI, USA |
Ok. I will try it your way for the time being. Thanks.
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 24th May 2013 - 06:14 PM |