Record username of last modified when query is edited

[jehanim009]

Hi,

I've used the fOSUsername() macro to record usernames easily in forms previously.



However, I now need the following:

a) Generate a query via a filtering form.

b) The query should have a checkbox field which has to be ticked if a record is valid.

c) The username of the person ticking each record should be recorded in a separate field.

I've completed parts a and b.

However, I'm not sure if adding a macro into a query in order to complete part c is possible.

Please help!

[ItsMe]

You can call a VBA function sub-procedure, like fOSUsername, from a query and use the value that the function returns. However, you have an additional requirement of using an Event. Events are triggered by Users. For instance, changing the value of a control.

I suggest you use VBA code behind a bound control's AfterUpdate event to update the UserName field in you table.

[InsuranceGuy]

If your intent is to take action based on changes on the query, attach the query to a form, then you can capture on_change to call your function and set your modified_by field to the user ID. I don't believe you can do this outside of a form for update events.

Cheers,

Jeff

[ItsMe]

...you can capture on_change to call your...

I would not recommend the OnChange event in this circumstance because this event for a control will fire every time the Text property changes. For instance, every character that is typed into a text box control will fire the event, once for every character typed.

[HiTechCoach]

Also cross posted here: http://www.access-programmers.co.uk/...29#post1464329