flipper67
Apr 10 2006, 11:53 AM
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
Apr 10 2006, 11:54 AM
Yes, that would be the way to do it.
dashiellx2000
Apr 10 2006, 11:56 AM
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
Apr 10 2006, 11:57 AM
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
Apr 10 2006, 12:00 PM
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
Apr 10 2006, 12:22 PM
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.