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
>
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.
