Pre-filling values (depending on the subform selection) while adding new records

[Maxihero]

Hi guys,

I am in the following situation - I have a form which contains a subform with records from two tables (with relation). Now, if there is selected a record in the subform I would like to add a new record as follows - I want to pre-fill the values (depending on the selected record in the subform) from just one table and let the user fill the values from another table. Is there any (easy) way, how I can make this please?

Many thanks,

Michal

 

[jdraw]

Can you give us more info about the tables involved?
And in plain English can you give us a description of what you are trying to do?
There may be options.

 

[Maxihero]

There are two tables - one called "Funds" and one called "Classes" which are related with "one-to-many" relation (for one fund we can have many classes). Both tables are showed in the subform. Now, when I want to add a new record to the subform, having a certain record selected (in this subform), I would like the "Funds" table values corresponding to the selected record to be pre-filled.

Hope it's more clear, but please, do not hesitate to ask me in case of any further questions.

 

[jdraw]

??? Why are both tables in the subform??

The one table Funds would be in the mainform and
the many Classes data would be in the subform.

The record in the Fund must exist before you can add a corresponding/associated record in the Classes table.

 

[Maxihero]

I must leave it this way (It is an imperativ).

 

[jdraw]

It may be an imperative, but we still don't know what you have. Many issues that posters face are the result of structure/design "problems". I'm not saying your design is wrong, but I think you should show us your table layouts, and tell us in plain talk WHAT you're trying to do.

There may be options/alternatives, but we need more info if we are to offer more focused assistance.