Multiple data entry form

[elGundzios]

Hi, I am new and I can't find search option on this forum. If I ask previously asked question the reason is I don't know how to search here.

I use Access 2010. My dream is to solve this:
I got one table called Trainings which stores mainly numeric ID's. There is PersonID, TrainingID, TrTypeID etc. I created two forms based on Trainings table. Main form with PersonID only and sub form with other data as continuous.
The idea is that I can record many trainings for one person.
I linked this forms via Trainings.ID as suggested by Access and this is not working.
I bet there is simple solution to this problem. After days of researches I didn't move at all. Please help.

 

[plog]

The idea is that I can record many trainings for one person

To achieve that the subform should be linked to the main via PersonID.

 

[isladogs]

For info, the search option is in the blue bar above the posts next to New Posts

 

[elGundzios]

To achieve that the subform should be linked to the main via PersonID.

I tried this. The error message is that I want to make duplicate entries.

 

[Uncle Gizmo]

Hi, I am new and I can't find search option on this forum. Please help.

Certainly! You can search the forum using Google. Full instructions on my website here:- "Searching For Answers" and if you can't find what you want with Google try Eckhart Tolle

 

[elGundzios]

I am not stubborn with the solution I presented in my initial post.
If there is a method of entering data to one table using one value once and add other values ... It can be described opposite, few values for particular training once and add names of attenders.
I have read few treads from this forum and nothing is close to my problem.

 

[plog]

I created two forms based on Trainings table. Main form with PersonID only and sub form with other data as continuous.

So both forms are based on Trainings? That should work, but seems odd. The main form should be pased on your Person table. In the subform properties what does it say for 'Link Master Fields' and 'Link Child Fields'?

 

[elGundzios]

I left links as suggested by Access - ID in both cases. ID refers to Trainings.ID as far as I can understand.
I wander why you have said "odd" and what do you mean by "The main form should be passed on your Person table".
When I created initially this form in Access 2016 it was working fine. Unfortunately at work I got 2010 version.

 

[isladogs]

Sorry I'm not clear about what you are trying to do
BUT you say it worked in A2016 but not in A2010

The obvious question is whether you have version specific references which are marked MISSING.
If so, some of your code won't work & the db won't compile.
Haver you checked that?

 

[plog]

I'm sorry, I mistyped. The Main form, the one for the Person should be based on your Person table.

 

[elGundzios]

The Main form, the one for the Person should be based on your Person table.

I try to populate table Trainings with data. Why should I touch other tables?

 

[JHB]

I try to populate table Trainings with data. Why should I touch other tables?

Because it so it works, with main- and subforms.
I suppose you have a table with data for a person from where you get the PersonID, so you mainform is based on that table either with a query or direct to the table.
Your subform is based on the Trainings table.
Then you link the mainform and the subform by the PersonID, using the "Link Master Fields' and 'Link Child Fields'.
If you can't get it, post you database with some sample data, zip it because you haven't 10 post yet.

 

[arnelgp]

maybe something similar to what you want.

 

[elGundzios]

Hi arnelgp!
You did fantastic work for me. Eye opening example, not only from technical but design as well!
It is shame there is only one Thanks button per answer. You deserve more!

It will take me a while to decipher your project, but I already know that the answer is there.
Thank you once more. I really appreciate your effort.

 

[arnelgp]

thanks also and have a nice day.

 

[elGundzios]

Hi arnelgp,
I tried hard to see mechanics of the form in your DB. I can see how particular fields on the form are connected together, but I can't see how data are linked to table Trainings to be stored.
Hopefully the last question in this subject. When you start a form, do you use any Access help like wizards or you start with blank form?

Have a nice weekend!

 

[elGundzios]

Thank you Pat!
It is interesting piece of DB. Gave me different ideas and ... more questions!
But you are right. I have to make sense of it for myself.