New Record not pulling through?

[Jay]

I have a form (frmMain) for the adding of new records, which also contains a
button which lauches a form based on a query. The query looks at the
'EnquiryID' field on the frmMain & pulls related other fields from that
record into an email template.

However, if a new record has just been added to the form & the query/form
lanched straightaway with the command button, that 'new' record isn't being
pulled through as it is effectively not showing in the source table until
frmMain is closed.

How can I get the query to recognise a record that has literally just been
entered in the same form, and the form is still open? Is there something I
can add to the command button code to effectively force that new record into
the table?

Sorry if I'm not being clear but I'm still getting to grips with Access.

Thanks,
Jason

 

[Pieter Wijnen]

sure

add me.dirty = false before invoking the new form to force a save

HTH
--
Pieter Wijnen

My feeble Access pages (good links though)
http://www.thuleeng.com/access
When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca/
http://allenbrowne.com/
http://www.lebans.com/