Automatic Input

[Mark Cambridge]

I am fairly new to access, hope someone can help.

I have four different forms in my database, based on four tables. each form has a certain number of fields that are the same name and type. e.g.

form 1 - serial number, event, start date, end date
form 2 - serial number, event, start date, end date
form 3 - serial number, event, start date, end date
form 4 - serial number, event, start date, end date

The rest of the form in each case is different, they go to different people. I want to be able to input data in form 1 and have it automatically entered in forms 2,3,4. This would save alot of time and repetition.

I've tried all sorts of things and is really drivin me nuts!!!

Anyone help????

 

[spiderq]

I am fairly new to access, hope someone can help.

I have four different forms in my database, based on four tables. each form has a certain number of fields that are the same name and type. e.g.

form 1 - serial number, event, start date, end date
form 2 - serial number, event, start date, end date
form 3 - serial number, event, start date, end date
form 4 - serial number, event, start date, end date

The rest of the form in each case is different, they go to different people. I want to be able to input data in form 1 and have it automatically entered in forms 2,3,4. This would save alot of time and repetition.

I've tried all sorts of things and is really drivin me nuts!!!

Anyone help????

Hi Mark

What is your relationship between the tables?I assume that the same data goes into one table from the 4 forms- what about a form based on the table with the data above and then use subforms. It does depend on how your database links together.
If you create a form based on the table, enter your initial data then use a command button/macro to call your form and subforms up to enter other data. Hope that helps.

 

[Mark Cambridge]

Hi Mark

What is your relationship between the tables?I assume that the same data goes into one table from the 4 forms- what about a form based on the table with the data above and then use subforms. It does depend on how your database links together.
If you create a form based on the table, enter your initial data then use a command button/macro to call your form and subforms up to enter other data. Hope that helps.

Cheers chap,

I sort of understood what you were talking about, but it gave me a brain wave, if i created one table then four forms of different names from it, then the same data would go into all forms, i tried it and it worked. thanks again

mark

 

[Rich]

Why do you need four different forms, when you only have one table?

 

[Mark Cambridge]

Why do you need four different forms, when you only have one table?

Rich,

The forms are part of an event planning system in place, the top of each form needs to have the information about the event, such as dates, times, what it is, where it is, how many places available etc. beneath that information the forms are totally different and go to different people for them to fill in their relevant part, and then come back to me for approval, and get filed away in a paperwork system.