Data Saved to Table but Not to Form

[Melody]

Hello everyone. Current dilemma: I have a form that I enter data into. When I exit the form the data is saved to the appropriate table; however, when I go back into the form the data is gone. Why is this data not being saved to the form, but it is saved in the table?? Thanks in advance for suggestions!!!!

 

[mattstewart]

Is your form in Data Entry mode? Check in the forms properties, if data entry mode is yes, then your form will only display new records after it is closed. change it to no and it should display the data in the table it is based off of.

 

[Neal]

Data doesn't get saved to a form, only a table. If you want to view data in the form, you have to give it some criteria so it knows which record to display. It sounds to me like your form is set up to open empty so you can add a new record. To get it to open to a specific record, you probably need a switchboard-type form with a control on it where you indicate what record you want to see and either an event or command button that opens your original form based on the value in your criteria control.
I can walk you through it if you like.

 

[Melody]

MATT - Thanks for the response. It's not in Data Entry mode, and it's still not displaying. Thanks for the suggestion though!!

 

[Melody]

NEAL - I'll call the form in question Form II. You access Form II by a command button on Form I. Upon accessing Form II, I want Form II's displayed record to match the record on Form I. (The field CustomerID is a common field on both forms, and the "link".) The forms are linked fine. (Form II displays the same CustomerID as FormI), I enter the data, I close the form, and when I go back into the record, the only field data that shows up is the Customer ID. (The CustomerID is from Form I, and I have the criteria:
[forms]![Site Information Form]![CustomerID]in the CustomerID field on the form query - To tell the form to pull this field's value's off of the main form) So - Why is this the only field I can see when I go back into the form? THANKS!!!

 

[Neal]

It seems to me it should work. If your DB is not too big, and not confidential, I'd be glad to look at it if you e-mailed it to me.