Re: [AccessDevelopers] Keeping subform updated

[brij]

Title: Keeping subform updated

Hi Tobi   i read the query about "Keeping subform updated" but didnt get it. do u have MDB file and if it is possible please attach (zip file) it to get the extact problem.   thanks   Brij here. ----- Original Message ----- From: Hoffman, Tobi K (DYS) To: AccessDevelopers@yahoogroups.com Sent: Tuesday, November 29, 2005 10:38 PM Subject: [AccessDevelopers] Keeping subform updated I have a data entry form with a subform on a tab control - the fact that it's on a tab may be irrelevant, but maybe not   Instead of having dropdowns for the entries in the subform, I have a list box outside the subform, and want any entry clicked in the listbox to go into the subform, which I do in code, in the listbox OnClick event.  (This is to prevent duplicate entries in the subform.)  This works beautifully for the first record entered, but on the second entry, the subform comes up with the previous entry's selection, although the correct data is saved.  Now if I switch tabs (here's where it becomes relevant!), and come back to the tab with the subform, the selection process works fine.  I've been trying to assure that the record is saved before entering the subform data, but sometimes come up against the "You can't save the data at this time" message. When this works right, it's elegant, but when it doesn't, it is downright frustrating! Tobi Hoffman Dept. of Youth Services Boston, MA Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.