Full Version: Command Button
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
flipper67
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?
fkegley
Yes, that would be the way to do it.
dashiellx2000
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.
flipper67
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?
fkegley
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.
flipper67
Ok. I will try it your way for the time being. Thanks.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.