VBA code in Access 2003

[coolpal9]

Hi,

I have a database split into front end and back end. And the tables have also been linked to each other.

My database has a detailed form to be filled by users. I want all the data entered through the form to be automatically duplicated in the tables in the backend.



I vaguely know that there needs to be a code in VBA. I donot know how to do that...

How shall I go about it?

Pl help....

[orange]

This may helpith splitting the database
http://support.microsoft.com/kb/304932

[coolpal9]

Thanks a lot!

[coolpal9]

Hey I tried doing it that way, but still I don't get my tables updated by mere filling up of the form.

Is there any other pre-requisite I need to follow?

As in, in naming of the tables or so..?