Records not saving

[stevelum]

I know I know yes bash the newbie on the head but I was so engrossed in making my database (which i have not done since access 2003),and I have hit the most unbelievable wall which most people would not give a second thought but here goes.Why when i fill in say record No 1 on my form and i press the save record button (which i would prefer not to do) does access not save the record.Once i leave and go back later record No ones fields are all blank again

 

[jdraw]

Readers need to see some code or additional info for context. We have no idea what you have/have not done.

Developing a database often follows:

- Identify a business issue to be assisted/supported with database
- clearly identify the business issue in plain English
- create a model (on paper) of proposed tables and relationships
- create test data to illustrate business info
- use test data to validate the data model
- reconcile every issue
-develop the database based on the "proven" data model.

 

[stevelum]

HI,

I don't think showing any code will help with my problem as the code is not the issue i have created a table and a form the control source are those fields in the table ,so i should be able to enter data into the felds on the form which then populate the table .So when the form is opened its starts on records No 1 and i enter data,however when i come out of access and go back later all the fields in record No 1 are blank it has not saved anything

 

[jdraw]

Make a zip of your database and post.

 

[stevelum]

This is a company computer they will not have any zip programs on here im lucky its got an off and on switch

 

[Gasman]

Basic use of Access does not require Save buttons if the data is bound to the form, which as I understand it, is the normal way of using Access. All you need do is move off the record.?

 

[Gasman]

This is a company computer they will not have any zip programs on here im lucky its got an off and on switch

Even XP has a zip program. Right click the db and use Send To/Compressed (zipped) Folder

 

[stevelum]

This is exactly why I am confused in access 2003 that's how it worked i used to go to record No 2 and when I went back to record No 1 everything was as i left it that's not the case at the moment.

 

[stevelum]

They are using windows 7 but you know corporate systems they lock everything down as all my fields are bound this should be saving I think I will look in my 2007 book as I am sure there will be other hurdles to overcome

 

[Gasman]

It works the same in 2007. That is what I used when I was working for a big bank, and even they had not disabled right click option for Send To, and they were pretty paranoid.
Can you edit the table directly?

 

[GinaWhipp]

-Hmm, what line are you using for your Save command? If more than on line please post.
-If you look at the table after adding your record is it in there?
-What version of Access are you using?
-What version of Access was the database created in?
-Have you ran Debug>Compile to make sure all your code compiles?
-Have you ran Compact & Repair?