I have a very basic database set up. I created a form for data entry. When I enter data into it, it does not transfer to the table. The info that was already in the table did go to the form, however.

Once in a while when I first turn it on, it will take the first record I enter and pull it over, then that's it.

Tried setting it to always enable macros and that didn't help.

Is the form bound to the table? Is the form set to data entry? Do you have any code behind the form or a save button that isn't working?

Is the form bound to the table? Is the form set to data entry? Do you have any code behind the form or a save button that isn't working?

How do you bound it to the table? When I created it, it was based on my current table. Occasionally data transfers over.

Yes, form is set to data entry - if by that you mean that it allows me to enter data into the form.

No code. No save button.

I'm going to have trouble explaining this, but I'm trying from scratch to figure out what's going on.

Created a new database with just name and phone number. Entered 2 records on the table. Created a form. The form appeared with those 2 entries. Typed a third name and phone number on the form. It did not appear on the table.

However, when I went to add another name directly to the table, it gave me an automatic ID of 4. So the one I entered into the form was not appearing, but was registering.

When I then made another form from the same table, all 4 records appeared in the new form.

I'm very confused and frustrated.

Can you upload your db without any sensitive info? I haven't ever heard of it updating sometimes and not others if it was set up correctly...

Or maybe someone else knows what questions to ask you. But I work better at problem solving by seeing. :)

Can you upload your db without any sensitive info? I haven't ever heard of it updating sometimes and not others if it was set up correctly...

Or maybe someone else knows what questions to ask you. But I work better at problem solving by seeing. :)

Thanks. Turns out I'm just an idiot. When I hit the refresh button it works. lol.

Thanks. Turns out I'm just an idiot. When I hit the refresh button it works. lol.


Well, don't be too hard on yourself, it's those types of things that help us learn for the future! :D I am glad your problem was solved.