Help Please, form not displaying records

[goldwhispers]

I can't figure out why my form will not display the records that have been input, they are shown in the table but not the form, help please!!<br><br>It saves the records to the table but it not showing it in the form.&nbsp;&nbsp;I input the details in the form but when I re-open the database I can't see the records in the form, only in the table...can someone help please, I am desperate

 

[RoyVidar]

I'm not sure I understand quite what you're problem is, but here are some tips.<br><br>You're probably opening the form in add-mode<br><br>If you're opening this form simply by dbl-clicking the form icon, i suggest you look at the data properties of the form, and change the Allow Edits, Allow Deletions and Allow Addition properties to yes.<br><br>You might wan't to have a look in the forms on open or on load event, to check out whether there are any DoCmd.GoToTecord acNewRec ' Remove that line, or modify according to needs<br><br>If you're opening the form through the Swithcboard Manager, check what mode you're opening the form in (it might be add-mode)<br><br>

 

[goldwhispers]

I am opening it in the switchboard, but i am not sure how to change it from add mode?

 

[RoyVidar]

This might not be accurat concerning the actual menu-names, cause I currently use a non-english version, but...<br><br>On the Tools-menu, select &quot;Database tools?&quot; and &quot;Switchboard Manager&quot;.<br><br>Browse through the different items til you find your form, select Edit, and you should be able to find the text &quot;Open 'your form' in add-mode&quot;, change it to &quot;edit-mode&quot;<br><br>Hope this is helpfull;-)

 

[goldwhispers]

thanks, thanks that worked...!

 

[magezi]

Try to open your form in Design view; Click in the blue top of the form using the right mouse button then Click Data Sheet view; Do you see your Records ?<br><br><br>Mail me at <br><br><A HREF="mailto:nkabirwa@netscape.net">nkabirwa@netscape.net</A><br><br>If So then your ; you are opening the form with an acNew instruction .on Load event.<br>Try also to check on the total no. of record displayed at the bottom of the screen when you open the form <p>Nkabirwa Sowed Magezi<br><a href=mailto:nkabirwa@netscape.net>nkabirwa@netscape.net</a><br><a href= > </a><br>A Ugandan Developer for<br>
(1) School Management Information System(SMIS) - Foxpro 2.6 ; Ms-Acess 97<br>
(2)Debt onitoring System(DMS) - Ms-Acess 97<br>
(3) The Loans Recovery System(LS) - Ms- Access 97<br>
(4) The Dry Cleaners System(DS) - Ms- Access 97