Form data not displaying

[Naia]

I have recently created a new form that saves data to three different tables. I can enter information into the form, when I close the form I do not get an error message. When I reopen the form, however, the record is not there. The information was saved to all three tables. Why is the form not displaying?

Thanks, N

 

[KeithG]

do you have the form set for data entry?

 

[rosito]

See: Form(Design view) -> Proeperties -> Data -> DataEntry = NO

 

[Naia]

My data entry is set to NO, but I don't think that is causing the problem.

I want to be able to enter data on a new form but also be able to scroll through and view historic forms. My current problem is I am able to fill out a new form but once you click off of it, you cannot return to it even though the data is stored to the tables

 

[missinglinq]

My current problem is I am able to fill out a new form but once you click off of it, you cannot return to it even though the data is stored to the tables

We need to clarify something! You say "I am able to fill out a new form." I'm guessing you mean new record; is this correct? If so, please explain a little more about the "once you click off of it, you cannot return to it even though the data is stored to the tables" part. Are you entering a new record, then going to other records in your form, then trying to return to your new record?

 

[Naia]

I have a form with 100 records. I create a new record each day. Sometimes I need to reference an old record so I scroll back in the form for find the record I am looking for. I have recently created a new form. This form allows me to create a new record, but if I close out the form and reopen the form, the record was now saved. However, the information was saved to the data tables. Why isn't the record saving?

 

[missinglinq]

"...the information was saved to the data tables. Why isn't the record saving?"

The information and the record are one in the same! If the information was saved the record was saved! What you mean is the record isn't viewable in your new form. You say that Data Entry is set to No. Exactly how are you opening the problem form, i.e. from the Forms Tab in the Object Dialog Box, form a command button on another form, etc? If from a command button on another form, we need to see the code you're using to open the new form.

 

[Naia]

I appoligize for my Access vocabulary not being quite up to par.

I am opening the form from the forms tab on the database window.

 

[Naia]

I have dug a little deeper into the problem. I no longer think the record is not saving in the form. The records are just out of order. How can I control the record order?

 

[missinglinq]

This is what I was trying to get at earlier; I suspected that the record was there, just not where you expected it to be! You say you're adding data to three separate tables, so I assume the form is based on a query. If you go to the Query Tab and open your query in Design View, you can sort on any field you want and the sort will show in your form. You can even use multiple fields to sort, if yu want. The only thing to remember in a multi-field sort is that Access moves left-to-right when sorting. For instance, if these fields appeared like this

Customer City State

and you want to sort by State then by City then by Customer, you'd need to re-arrange your fields like this

State City Customer