I have a form that is bound to a table. It has two unbound list views that have sql queries as the rowsource.
I can add a record to the parent form, but it will not save until I close and reopen the form.

When I try and use docmd.runcommand accmdsaverecord, I get error 3021.

This is only happening on two forms in my app that has around 50 forms that are working just fine.

I am sure it is something simple, but I have not been able to find anything on the UA

Ryan

In what event are you trying to save the record?

Hi Ryan,

I think we'll need more information from you. You started saying that you have a "form" but then discussed the problem with a "parent" form. Also, it should not be necessary to close and open the form to test if it's saving the record. Are you getting any errors by just moving from one record to another? Have you checked if there are any differences in the properties between you problematic form against those that are working properly?

Just my 2 cents...

And a good 2 cents it is

Hi Brian,

Welcome to Utter Access!

Thanks. Do you think 84 posts for my first day is a bit much?

It's actually good. It gave us old timers a chance to rest for the day.

The funny thing is that, as a lark, I went to the members page and had it page at 60 per page which gave 1588 pages of members. Which then I looked for me and I was on page 40 (in descending order). So I moved up 1548 pages just today

It was a very good day for you, then. Congratulations! It's getting late in my neck of the woods, so I'll have to say good night. I won't be surprised if I see you're still at it when I get up in the morning.

Goodnight - sleep well.