08-06-2013, 07:26 AM #3 SyntaxSocialist Newly Registered User Join Date: Apr 2013 Posts: 109 Thanks: 25 Thanked 1 Time in I've try this setup code Private Sub cmdSaveAndClose_Click() DoCmd.Save 'requery list Forms![MainForm]![subformName].Requery '' I've also tried these 'Forms![MainForm]![subformName].Form.Requery 'Forms.("MainForm").[subformName].Requery 'Forms.("MainForm").[subformName].Form.Requery DoCmd.Close End Sub None of these attempts seem to work.

Maybe we'll have this thing solved by End of September! Instead, users must edit the items in the Row Source property box, or in the case of lookup fields, edit the items in the table that contain the source data for They have to pay for every time they want the server rebooted. I don't know how to do this error handling part, can you show me?

Thanks! --------------------------------------------------------------------------------------------- MarvinM View Public Profile Find More Posts by MarvinM Tags data entry , edit , form access , new record , vba « TECHNOLOGY IN THIS DISCUSSION Read these next... © Copyright 2006-2017 Spiceworks Inc. The Allow Value List Edits command appears on a shortcut menu that you open by right-clicking a list box or combo box control. http://www.access-programmers.co.uk/forums/showthread.php?t=251496 I've listed the various articles on this issue together below.

To do that, you use an append query. Please see: KB 2827138 Access encounters multiple issues if the PC has been running more than 20 days http://support.microsoft.com/kb/2827138/EN-US Your feedback has the attention of the Access development team. I'm hoping I can get him connected to a customer's computer and gather some info. You can then apply different fonts, sizes, styles, and colors to your text.

Unless there is a way to requery the subform from the parent form when the other form is closed, I can't try the later syntax. –Tony L. page Some people find the compile-time checking and the better Intellisense worth that risk. Tomorrow we`ll trying to reboot the server. I've got a support case opened with Microsoft to have this issue looked at in detail as soon as we can get the issue to come back up on a machine

For information about using an Attachment field, see the article Attach files and graphics to the records in your database. check over here KB2965300 says it will reintroduce the problem, but I don't know if it was part of the normal updates. Are there any server options for MS Acces for calculating? Top of Page Use an append query to add records to tables One of the most frequent uses of an append query is to add a group of records from one

Allow Value List Edits Lookup tab Yes/No Enables or disables the Edit List Items command for value lists, but not for lookup fields. Oops, something's wrong below. For example, suppose that you acquire some new customers and a database containing a table of information about those customers. his comment is here I was wondering: Is anyone else is getting this problem without out updated been installed?Has anyone had any contact with MS (I note Derek-d'O comment on the 7/Apr) regarding fix/updates/solutions?KernelSoftware, you

This figure shows a typical table in query designer: Drag the fields that you want to append from the table to the Field row in the lower section of the query Only a reboot will fix it. Also to confirm the problem is not in my code I made a totally new accdb with 1 table, 1 query, 1 form and still had the same issue.

The last two times I had this problem (in the last few months) it seemed to get fixed with a Windows Update.

At one of them, pressing F9 refreshes the fields; at the other, nothing works. You can use the form's Close event to force a save like this: Private Sub Form_Close() If Me.Dirty Then Me.Dirty = False End Sub Bill Mosca www.thatlldoit.com http://tech.groups.yahoo.com/group/MS_Access_Professionals Tuesday, January 06, The query designer opens, the Design tab appears, and the Show Table dialog box opens. Views button / Conditional Formatting button Proposed as answer by meme427 Friday, March 28, 2014 4:06 AM Unproposed as answer by meme427 Friday, March 28, 2014 4:06 AM Tuesday, January 28,

I thought of rebooting the computer but haven't had time. They are running in the background and after a time we have this problems, with the reboot of the server or the machines, the programms are closed, so the problem is When they do, you can alter your primary key value and have that change automatically cascade through all related child records. weblink Change data in a datasheet In the Navigation Pane, double-click the table or query that contains the data you want to change.