Mainform w/Multi tab subForms and one record to update - How?

[EdV]

Hi , I'm new to this forum , and this is probibly old news to you. here goes..

I have a main form with 7 tab subforms that was broken up to address all the various input data. I want to access the same database record for update between the 7 tabbed forms. At any time I want to add form data(1-7) to any part of a "new" or "existing record already created" which is currently not indexed(many side) - is this a problem?

How do I locate> lock> update ie .. (old school)..Re-Write the same record?. That way I don't have 7 partial records for one primary key record in the many side table.

form linkage to master/child links are working,
relationships between primary key(claim number) and other tables with same key exisits - no prob there.

I've tried to use an update query to no avail.
I need to understand better the code that can select the table record for update base on key.
I want to avoid creating duplicate key records with partial data
all subforms are linked - master/child etc..
I have a combo box to see the parent indexed primary records(1 side)
The form captures medical data between these 7 subforms.
The main form contains claim number and name data from the primary key
The subform contains various event related data and is linked to the main table as a relationship.


Well, Howdy doody! help that addresses this would be appreciated . If you can show me what I am doing wrong please tell me.

How to do it with RS... or select distrinct row etc... ideas are welcome.


Cheers
Ed Vega

 

[Pat Hartman]

The RecordSources for the forms on tabs 2-7 need to be queries with criteria that reference the record ID on the form of tab 1.

 

[EdV]

Hi Pat, you say it needs to be controlled by queries? as in an update query?

or other select query and use the criteria slot for the key search? I'm not clear on this part.


Cheers
Ed

 

[Pat Hartman]

Not update queries, you need select queries as the RecordSource for each form.

Select ...
From ...
Where SomeField = Forms!YourMainForm!TheKeyField;

 

[EdV]

pat, ahh ok a simple query will do it? i'll try it , and get back with my results .

thank you pat

Cheers
Ed