Open new form using command button and add records

D

D'Lilah

I cannot figure this out. I have a form ("frmNewClients") with a subform
("sfrmClientDetails") linked by [ClientGroupID]. I want a command button on
"frmNewClients" that opens another form ("sfrmDocuments") which is linked by
[ClientID] in "sfrmClientDetails". I want "sfrmDocuments" to open to records
based on what is selected in the subform "sfrmClientDetails". Sometimes,
there will be no records to show in sfrmDocuments, so I will need to add
them. Other times, there will be existing records to be updated and new
records to be added. When I add new records, I would like the [ClientID] to
automatically be filled in based on the current open record.

I have tried so many options that I am now too confused and have to start
from scratch. Any help would be greatly appreciated. If further information
about the database structure is needed, please advise.

Thanks in advance.
 
Top