Records save in tables but not in forms

[Guest]

I have 116 records saved on a table in my db. I can use a form to enter new
data in the table (let's say I add record #117). I can view record #117
through the form as long as the form is open. However, once I close the
form, I can no longer find record #117 through form view; iInformation from
record #117 then becomes available only by looking at the table associated
with the form.

How can I keep new information visible in form view as well as table view?

Thanks for your help.

 

[Guest]

Open the form in design view and open the properties box. Go to Data column
and you will see DataEntry in the Data column. Ensure you select the = NO
option

Hope this helps

 

[Guest]

Thanks Wayne-I-M. I had already checked that and the property was correctly
set. The db is located was working properly before being added to a network
drive. Might this have something to do with it?

 

[Guest]

Almost certainly

Have you split the database yourself ?

 

[Guest]

Have a look at this excelent site

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Van T. Dinh]

Perhaps, you should post the details of the relevant Tables and the
RecordSource for the Form. If the Form's RecordSource is a saved Query or
an SQL String, post the SQL String. I know of one case where to reduce the
network traffic, the developer used:

SELECT *
FROM Table1
WHERE PKField Is Null

which returns an empty but updatable RecordSource for the Form.

Also check the Filter Property in case you have something in it that could
affect ...

 

[Guest]

Thanks for all the suggestions. After reading through some of the other
forums, I decided to check out the table relationships. It seems that the
relationships were somehow deleted when the file was transferred to the
network drive. I restored the relationships between the tables and this
seemed to fix the problem (at least for now :-O)