linking forms

[bogglebeats]

is there any way to link forms without declaring subforms? i have a form called clients information and a subform within that called counseling session. i also have a form called workshop and a subform within that called workshop attendees. there is a field on the counseling session subform called 'workshop title' that the user can enter in. if the titled is entered in (or chosen - i can change to a listbox), then this makes the client a workshop client. what i want is to update on my other forms (workshop, workshop attendees) if the client is declared a workshop client on the counseling session subform (by choosing the workshop title). i would like for the clients name to show up as a workshop attendee subform. is this possible?

 

[casey]

Is there a reason that you don't want to use the subforms? If you reference them correctly then you should be able to do what you want using them.

If you're confident w/ your VB then I'll give you some suggestions, but to describe exactly how to do this using VBA would take too long.

Declare a DAO.recordset to navigate through the form's recordsets.
coding....

Dim rs as DAO.recordset

set rs = Forms!YourForm.Recordset
rs.FindFirst "YourClientPrimaryKey=" & Forms!YourMainForm.YouControlName
:
:
'When you're finished then
Set rs = nothing

Like I said...You probably can do what you want w/ subforms. Let me know if this makes any sense and I can try and assist.

 

[bogglebeats]

the reason i did not want to use subforms is because the clients information form (the parent form) is based around clients and if i were to use subforms they would revolve around clients too (like my counseling session subform). i would like the workshop forms to revolve around the workshops. as in one workshop can have many clients (workshop attendees form) is there a way to accomodate both bases (clients and workshops) using subforms? access only lets me create one to many relationships (clients information form being the one side). please help! thanks.