Subforms

[FLGuy]

Currently I have a access 2007 database that has a form that is used to enter
client support calls. I was asked to make this a into a split form that would
show the clients call history at the bottom of the form. I created a split
form with a dataset view at the bottom. But this shows all data in the table.
What I want to happen is when I enter the client number in the top have of
the form I only want it to display the records for that client in the bottom
dataset. What is the best way to get this to work.

 

[Maurice]

You need to create a regular mainform - subform combination. Make the
mainform based on clients and the subform based on clientcalls. When you've
created the mainform add the subform from the toolbox and Access will provide
you with a possible key combination for the master child field. In your case
this will probably be clientID. When added close the form and reopen it. You
shoul now only see client calls connected to the client which is current.

hth

 

[FLGuy]

Thanks that worked great.

You need to create a regular mainform - subform combination. Make the
mainform based on clients and the subform based on clientcalls. When you've
created the mainform add the subform from the toolbox and Access will provide
you with a possible key combination for the master child field. In your case
this will probably be clientID. When added close the form and reopen it. You
shoul now only see client calls connected to the client which is current.

hth