to add the line of code that I suggested below to the click event of the
button just before opening the second form. A Requery of the Subform when
you save and close the record in the other form should get it to display on
the main form.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of eileen1309
Sent: Monday, May 08, 2006 3:41 PM
To: [email protected]
Subject: [ms_access] Re: Issue with subform refresh or requery?
The button to open the subform(detail) is on the tab itself. On the
mainform I have an field called description that is required so I
have an afterupdate event which saves the record.
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote:
>
> If the user is actually moving focus to the subform, Access should
> automatically save the new outer form record. Is the "Enter New
Party"
> button on the outer form or in the subform? If on the outer form,
you might
> need to make sure the outer record is saved before opening the new
form.
>
> If Me.Dirty Then Me.Dirty = False
>
> In the new form, make sure you save the record before closing and
to a
> Requery of the subform control back on the main form.
>
> John Viescas, author
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> Running Microsoft Access 2000
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
> For the inside scoop on Access 2007, see:
> http://blogs.msdn.com/access/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf
> Of eileen1309
> Sent: Saturday, May 06, 2006 7:26 PM
> To: [email protected]
> Subject: [ms_access] Issue with subform refresh or requery?
>
> Hi Everyone,
>
> I have a mainform and subform, which is on a tab, after the user
> enters a new mainform record they can go to the Party tab which
> presents a list of corresponding names associated with the
mainform
> record.
>
> Here's where I have an issue, After entering a new mainform record
> the user enters goes to the party tab (subform) and clicks enter
new
> party which opens a new screen for the user to enter detailed
> information. When this form is closed and they are returned back
to
> the mainform record the Parties tab (subform) is not refreshed to
> reflect the newly added record.
>
> I have tried several attempts to get the party record entered to
> reflect but no such luck.
>
> on the main form I set an event on the gotfocus to
me.parent.requery
> but still no result. However, if the mainform record exists and
> they are adding another party it is reflected immediately. It is
> only when entering a new mainform record.
>
> If anyone has any ideas please let me know.
>
> Thanks for any assistance.
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" 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.
