Subform Issue (multipost)

[accessquestions]

This is a Multi-Post (posted on access.forms), but no response, so Im nit
sure if it was the appropiate groupl so Im trying again.

I am trying to create a Form/Subforms based on the MS Access Template 2003
entitled "Contact Management". If anyone is familiar with this Template,
please reply.
I ask this question because I am an amateur with Access, and for you to have
an understanding of what I am trying to accomplish would alleviate me trying
to explain what I am trying to do in great *confusing* detail.

I will attempt anyway:
Tables:
Calls
Customers

Main Form: Customers (Contact info) Works Fine
Subform: Calls: Datasheet View w/ Timestamp Works Fine

Subform 2: Call Notes: Separate subform from Calls (want to see it in Form
View) - However, this I where my problem is: When I jump to the next
record, the Form and Subform 1 move to the next record, but Subform 2 does
not.

I tried linking Master and Child Fields to the CallID of the Calls table,
but it is not an option.

I hope someone out there knows what I'm trying to explain !

Thank you

Vinnie

 

[Douglas J. Steele]

You say that it's "not an option" to link the form and subform. Presumably
they should be linked on CustomerId. If you're unable to link them, that
implies either

- You don't have CustomerId as a field in the recordset for one (or both) of
the forms involved
- One (or both) of the forms involved isn't bound

 

[Ron2005]

one way or the other you have to apply some criteria to the second
subform to tell it which record to use.

If it is currently a query with the criteria of the id or whatever of
the primary form then one way to get them to sync is in the oncurrent
event of the main form issue a requery to the second subform.

Note: if the second subform is NOT a true child form with a parent
child relationship then you will also have to add in the before insert
event of that second subform code to load the id/key of the main form
into the foreign key of that query.

Ron

 

[accessquestions]

Your Note, that did it, awesome ! Thank you very much!