Entering and accessing records entered on a simple form

[Jeanie]

I am VERY new at using ACCESS and am trying to build my first data-base...it is very simple where I am tracking tasks for a project.&nbsp;&nbsp;The problem I have run into is that when I go into my form and enter records I can only go back to the records I have entered during this session.&nbsp;&nbsp;So, when I need to go back to my form and change it from open to complete, the only way I can access my information is through the table.&nbsp;&nbsp;So, I guess my question is how to do I attach the records to the form so that I can scroll through all the records in the table?<br><br>Any help would be appreciated!

 

[Guest_imported]

my guess is the form is set for data entry! just right click on the form and say remove filter this will show all records

 

[DougP]

First of all. Do you have a table for your data to go into?<br>If so then ...<br>Create your new forms from now on like this.<br>Click the Tables TAB and highlight the table you want to enter or edit data.<br>Then click &quot;Insert&quot; menu then &quot;Autoform&quot;<br>It will create form in seconds that is already connected to your data source.<br><br>Next open you new form in Design view<br>Click the &quot;View&quot; menu then make sure the &quot;ToolBox&quot; is on.<br>Hold your mouse over the toolbar on each item for a second it will show you the type of items you can add.<br>Make sure the &quot;Wizard&quot; button is depressed (button with wand and fairy dust)<br>Add a &quot;Command Button&quot; <br>in the &quot;Categories&quot; list pick &quot;Record Operations&quot;<br>In the &quot;Actions&quot; list pick &quot;Add New Record&quot;<br>Follow the prompts to &quot;Finish&quot;<br>Then you will have a button on your form<br>Next view your form. Click &quot;View&quot; menu then &quot;Form View&quot;<br>click your new Add Record button and key in your data<br>When you are done Click Add new again and add the next record and so on.<br>Now your data is going in your table.<br><br>Next lesson how to find your data with a query.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.