Multiple Forms carrying across data Help

[Makaveli]

Hi,

This is my first post, ive browsed through the forums and cant seem to find anything similar.

I have two tables,
table 1 is linked to table 2 via property ID in a one to many relationship
Property id is in table 1 and formated as an autonumber
in table 2 it is a number.

form 1 has all the details from table 1
form 2 has all the details from table 2

the only thing they have in common is the property id.

at the moment in form two you have to type in the property id manualy to create the link with form 2, surly as form 2 opens from form 1 theres away it can be automated so that it automatically selects the property id from the current record in form 1.

i've been baffled with this for two whole working days, any help would be much apprechiated

 

[MStef]

Put Form2 in Form1 as a SUBFORM.
Populate "LINK CHILD FIELDS" and "LINK MASTER FIELDS" properties.

 

[Makaveli]

I cant use a subform there wouldnt be enough room. theres more than one form to be linked you see. I said two rather than having to list them all.

The real issue is form 1 links to form 2 which has another 3 forms attached, lets call them 3 options for now. if i click onto form two and select option 1, this needs to pull the property id from form 1 and filter all the records on option 1. (only two tables)
any ideas

problem two
i dont know if this is a common problem with access, when i format a form and select "allow additions" and turn this value to "no" it allows me to view the form ok, but every now and then when i open it it has no data and is just a blank grey screen until i go into design mode. then i have to change it back save it and repeat the process everytime access seems to think for itself.

(Access 2003)

 

[wiklendt]

The real issue is form 1 links to form 2 which has another 3 forms attached, lets call them 3 options for now. if i click onto form two and select option 1, this needs to pull the property id from form 1 and filter all the records on option 1. (only two tables)

you can't expect to get an answer/idea if you don't state your exact problem/situation/assets. second, MStef gave you a very good option, which i would urge also. And you CAN have subforms within subforms - these other mutliple forms you suddenly mention, are they subforms of the first two forms? are they different forms all together? you need to explain what you have and what you want.