r/MSAccess•
whoisearth

Best way to pre-populate separate form?

I have a form called tblApplications which, on insert, I want to populate a separate form called tblApplicationsManagement.

The ID field from tblApplications will become the applicationid in tblApplicationsManagement. I'm dealing with legacy code and therefore can't integrate with a trigger but if I manually run the insert it works fine. I was thinking of calling a stored procedure or function on form_afterinsert which will create but I don't want the stored procedure or function running as the user but internal to the application. How would I go about doing this?

Posted Feb 22, 2016, 4:24 AM UTC

11
Loading comments…