Good Morning,

Can anyone tell me if using Allen Browne's Audit Trail would be different
for a main form versus a subform?

I've been using Allen's Audit trail for 3 different forms (all main forms)
and they work great. Now I've added one to a subform & everything works
except logging "EditTo" (it logs everything else).

Thanks Kindly

The logic is identical for subforms. No changes needed.

Temporarily disable the error handling. There is most likely a field out of
order, or missing (or mis-typed) in one of the tables--either the temp or
audit most likely.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gabby Girl" <(E-Mail Removed)> wrote in message
news:25F75616-7B76-47F5-94ED-(E-Mail Removed)...
> Good Morning,
>
> Can anyone tell me if using Allen Browne's Audit Trail would be different
> for a main form versus a subform?
>
> I've been using Allen's Audit trail for 3 different forms (all main forms)
> and they work great. Now I've added one to a subform & everything works
> except logging "EditTo" (it logs everything else).
>
> Thanks Kindly
>

Thanks Allen. I'll double check everything & let you know how it goes.

Rgds


"Allen Browne" wrote:

> The logic is identical for subforms. No changes needed.
>
> Temporarily disable the error handling. There is most likely a field out of
> order, or missing (or mis-typed) in one of the tables--either the temp or
> audit most likely.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Gabby Girl" <(E-Mail Removed)> wrote in message
> news:25F75616-7B76-47F5-94ED-(E-Mail Removed)...
> > Good Morning,
> >
> > Can anyone tell me if using Allen Browne's Audit Trail would be different
> > for a main form versus a subform?
> >
> > I've been using Allen's Audit trail for 3 different forms (all main forms)
> > and they work great. Now I've added one to a subform & everything works
> > except logging "EditTo" (it logs everything else).
> >
> > Thanks Kindly
> >
>
>
>

Hi again Allen

After doing everything you suggested "EditTo" still does not work. What I
have noticed though is on my form there are three fields that come from a
different table (form is based on a query, which is based on 2 different
tables-related) Could this be the problem? If so, is there a work around?

Thanks for your help.


"Gabby Girl" wrote:

> Thanks Allen. I'll double check everything & let you know how it goes.
>
> Rgds
>
>
> "Allen Browne" wrote:
>
> > The logic is identical for subforms. No changes needed.
> >
> > Temporarily disable the error handling. There is most likely a field out of
> > order, or missing (or mis-typed) in one of the tables--either the temp or
> > audit most likely.
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users - http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
> >
> > "Gabby Girl" <(E-Mail Removed)> wrote in message
> > news:25F75616-7B76-47F5-94ED-(E-Mail Removed)...
> > > Good Morning,
> > >
> > > Can anyone tell me if using Allen Browne's Audit Trail would be different
> > > for a main form versus a subform?
> > >
> > > I've been using Allen's Audit trail for 3 different forms (all main forms)
> > > and they work great. Now I've added one to a subform & everything works
> > > except logging "EditTo" (it logs everything else).
> > >
> > > Thanks Kindly
> > >
> >
> >
> >

I DONT Know gabby why dont you go to back to what you was doing be for and
see if you can log in after.
"Gabby Girl" <(E-Mail Removed)> wrote in message
news:25F75616-7B76-47F5-94ED-(E-Mail Removed)...
> Good Morning,
>
> Can anyone tell me if using Allen Browne's Audit Trail would be different
> for a main form versus a subform?
>
> I've been using Allen's Audit trail for 3 different forms (all main forms)
> and they work great. Now I've added one to a subform & everything works
> except logging "EditTo" (it logs everything else).
>
> Thanks Kindly
>

It can be done regardless of whether the form's RecordSource is a table or
query.

The temp table and audit table must have the same fields, in the same order,
and preferably with the same name. If not, the wildcard in the SQL statement
won't assign the fields correctly.

The SQL statement should throw an error if you used dbFailOnError. If not
perhaps the event is not being called. You could add a Debug.Print line to
the top of the procedure to see if it is firing.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gabby Girl" <(E-Mail Removed)> wrote in message
news:BFF50B49-FF22-4CBE-91D9-(E-Mail Removed)...
> Hi again Allen
>
> After doing everything you suggested "EditTo" still does not work. What I
> have noticed though is on my form there are three fields that come from a
> different table (form is based on a query, which is based on 2 different
> tables-related) Could this be the problem? If so, is there a work
> around?
>
> Thanks for your help.
>
>
> "Gabby Girl" wrote:
>
>> Thanks Allen. I'll double check everything & let you know how it goes.
>>
>> Rgds
>>
>>
>> "Allen Browne" wrote:
>>
>> > The logic is identical for subforms. No changes needed.
>> >
>> > Temporarily disable the error handling. There is most likely a field
>> > out of
>> > order, or missing (or mis-typed) in one of the tables--either the temp
>> > or
>> > audit most likely.
>> >
>> > "Gabby Girl" <(E-Mail Removed)> wrote in message
>> > news:25F75616-7B76-47F5-94ED-(E-Mail Removed)...
>> > > Good Morning,
>> > >
>> > > Can anyone tell me if using Allen Browne's Audit Trail would be
>> > > different
>> > > for a main form versus a subform?
>> > >
>> > > I've been using Allen's Audit trail for 3 different forms (all main
>> > > forms)
>> > > and they work great. Now I've added one to a subform & everything
>> > > works
>> > > except logging "EditTo" (it logs everything else).
>> > >
>> > > Thanks Kindly

Hi Allen,

I apologize for not answering sooner but I just got back. I will try to
debug to see if it's firing or not and will let you know.
Thanks again for your help.

"Allen Browne" wrote:

> It can be done regardless of whether the form's RecordSource is a table or
> query.
>
> The temp table and audit table must have the same fields, in the same order,
> and preferably with the same name. If not, the wildcard in the SQL statement
> won't assign the fields correctly.
>
> The SQL statement should throw an error if you used dbFailOnError. If not
> perhaps the event is not being called. You could add a Debug.Print line to
> the top of the procedure to see if it is firing.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Gabby Girl" <(E-Mail Removed)> wrote in message
> news:BFF50B49-FF22-4CBE-91D9-(E-Mail Removed)...
> > Hi again Allen
> >
> > After doing everything you suggested "EditTo" still does not work. What I
> > have noticed though is on my form there are three fields that come from a
> > different table (form is based on a query, which is based on 2 different
> > tables-related) Could this be the problem? If so, is there a work
> > around?
> >
> > Thanks for your help.
> >
> >
> > "Gabby Girl" wrote:
> >
> >> Thanks Allen. I'll double check everything & let you know how it goes.
> >>
> >> Rgds
> >>
> >>
> >> "Allen Browne" wrote:
> >>
> >> > The logic is identical for subforms. No changes needed.
> >> >
> >> > Temporarily disable the error handling. There is most likely a field
> >> > out of
> >> > order, or missing (or mis-typed) in one of the tables--either the temp
> >> > or
> >> > audit most likely.
> >> >
> >> > "Gabby Girl" <(E-Mail Removed)> wrote in message
> >> > news:25F75616-7B76-47F5-94ED-(E-Mail Removed)...
> >> > > Good Morning,
> >> > >
> >> > > Can anyone tell me if using Allen Browne's Audit Trail would be
> >> > > different
> >> > > for a main form versus a subform?
> >> > >
> >> > > I've been using Allen's Audit trail for 3 different forms (all main
> >> > > forms)
> >> > > and they work great. Now I've added one to a subform & everything
> >> > > works
> >> > > except logging "EditTo" (it logs everything else).
> >> > >
> >> > > Thanks Kindly
>
>
>