viewing my form

[Amanda]

I have a database that works great thanks to all of you. When I open my form
it opens on a blank form to fill out which is what I want but if I want to
view other forms that are filled out I can't from this form. On other
databases that I have seen you can open on a blank form and go to the bottom
and use the arrows to view different form that are already filled out. I
would like to be able to do this. If someone could help me I would greatly
appreciate it. Thanks in advance for all the great help!

 

[Klatuu]

I use a command button on a form like this. In the click event:
Me.Undo

 

[Amanda]

I'm not sure how to do that. If you could explain where to do this that
would be great. Thanks, sorry I'm still new to access.

 

[Klatuu]

Put a command button on your form.
In design view, select the button and open the Properties Dialog.
Select the Events tab
Select the Click event and click on the small command button with the 3 dots
When the next dialog opens, select Code Builder
The VB editor will open.
In the editor, Enter
Me.Undo

Then in form view, when you click the button, the new record will disappear,
and the first record in the form's recordset will show.

 

[DavidBoyle via AccessMonster.com]

I have a database that works great thanks to all of you. When I open my form
it opens on a blank form to fill out which is what I want but if I want to
view other forms that are filled out I can't from this form. On other
databases that I have seen you can open on a blank form and go to the bottom
and use the arrows to view different form that are already filled out. I
would like to be able to do this. If someone could help me I would greatly
appreciate it. Thanks in advance for all the great help!

I think you might need to change the NavigationButtons property of your form

 

[Amanda]

How would I do that?

I think you might need to change the NavigationButtons property of your form

 

[John Spencer]

It sounds as if you have set the form's data entry property to YES.

What this does is open the form to a blank record and NOT have any of
the other records in the table/query that the form is attached to be
available.

If you want all the records available you will need to set the form's
data entry property to No. You can still add new records.

If you still want to open the form on a new record, you will need to add
some VBA code to the FORM's Open event to make it move to the new record.

-- Click on the form in design view
-- Show the form's properties
-- Click on the Events tab
-- In the On Open "cell" enter or choose [Event Procedure]
-- Click on the button (...) at the end of the Event and open the VBA
window.

-- Enter DoCmd.GoToRecord , , acNewRec

 

[Albert D. Kallal]

check your form in design mode, and check the forms properties sheet.

You want to set the "data entry" setting on the data tab to "no"

And, if navigation buttons are not showing, you want to make sure they are
turned on, and in the above properties setting for the form make sure the
navigation buttons setting is yes (that is on the form tab).

 

[DavidBoyle via AccessMonster.com]

Open the form in design view - Go to the forms object tab, select the form
and then click the design view icon, using the scroll bars,

Either
---------

move to an area outside the viewable area of the form, this is dark grey.

Right click and choose "properties"

Or
---
Double click the square in the top left of the window


to open the property sheet for the form or report.



Click the "Format" tab

Navigation buttons is about the sixth on the list and can be set to Yes or No.


I'm looking at Access 2000 to give you these instructions but all versions of
access have similar functionality.

How would I do that?
[quoted text clipped - 5 lines]

I think you might need to change the NavigationButtons property of your form