Multiple Users and Information in Tables

[MChancellor]

I have a database that seems to be working pretty well, except for one minor problem. When I had the database stored on the harddrive of my computer, information entered on a form would be on the form as record number 1, 2, etc. when you opened the form. I copied and pasted what I thought to be the working database onto a network drive (so that it could be accessed from several different computers - users will probably only be about 3 or 4) and now it is not retaining information in the form - although the information is still in the table. Whenever you open the form is shows as if there were no other records entered. My question is: How do I get the information to remain visible on the form, even if opened on a different computer? and does anyone have any idea why it might be doing this?<br>
<br>
Thanks in advance,<br>
M. Chancellor

 

[DougP]

Open the form in Design view<br>
Click on Properties<br>
click on the square in the upper left hand of the form. You will know it if it say &quot;Form&quot; in the properties box.<br>
There should be something in the &quot;record source&quot; property<br>
If not then click the right side of &quot;record source&quot; box on the little down arrow. Choose the table to connect to.<br>
If your form is connected to a table or query then it will always show.<br>
If not then you have something else going on.<br>
The easiset way to connect a form to a table is click in tables view.<br>
Highlight the table which a form will connect to.<br>
click &quot;Insert&quot; menu <br>
click &quot;Autoform&quot; Near the bottom<br>
It will create a form automatiaclly and give you all of the fields and be connected.<br>
Then click the design button and add your buttons and so forth.<br>
<br>