Subform records wont display

[taylorosso]

Hi it's me again. One problem solved another problem found..



I have a subform which contains dated notes about a customer.

These notes display fine if you cycle through the customers using the record selectors but stops working when i navigate to a customer using my search function.

For some reason the subform does not refresh to match the newly searched customer.

Im just gunna uplaod my database so you can have a look at how the notes section works.

The image ive uploaded demonstrates the section you need to be looking at.

[sasipulikkal]

Hi..

I assume,with the click of search,u need to display the notes of the client.Depending on the Client u have searched,the records need to be displayed in the dated notes.rite?
Can u please write the code,what you have used now?

[RuralGuy]

In order for a MainForm/SubForm to stay in sync, the LinkChild/MasterFields properties need to have values that match.

[taylorosso]

Hi,

Yeah i have linked the notes and clients using the ClientID.


here is my search code

Private Sub Command3_Click()

On Error GoTo Err_Command3_Click

Dim stDocName As String
Dim stLinkCriteria As String

If Me.List3.ListCount > 0 Then
stDocName = "frmClients"
stLinkCriteria = "[ClientID]=" & Me!
[List3]
DoCmd.OpenForm stDocName, , , stLinkCriteria

DoCmd.Close acForm, "frmSearchClient2", acSaveNo
DoCmd.Close acForm, "frmSearchClient1", acSaveNo
Else
DoCmd.Close acForm, "frmSearchClient2", acSaveNo
End If

Exit_Command3_Click:
Exit Sub

Err_Command3_Click:
MsgBox Err.Description
Resume Exit_Command3_Click

End Sub

[RuralGuy]

Your explaination is not in what you posted in post #1.

[taylorosso]

sasipulikkal asked for any code so I gave him my code...

I am not using any other code related to the clients and notes.

[RuralGuy]

Based on what you posted in Post #1, the SubForm with the notes will not stay in sync because the LinkChild/MasterFields do not contain the same values.

[taylorosso]

ok, I set the link child master field values to "company name" and they still wont sync when i use the search.

When cycling through the clients using the record selectors it syncs fine

[RuralGuy]

The tblNotes table does not have a [company name] field so how did you do that?

[taylorosso]

The tblNotes table does not have a [company name] field so how did you do that?

I created it on the db on my system,

see attachment

[taylorosso]

I have had a thought,

could it be that the my search code is finding a client record but not actualy selecting that record hence my linked subform is not showing any data?

RuralGuy you may be able to help with that one.

Here is the search code once again;

Private Sub Command3_Click()

On Error GoTo Err_Command3_Click

Dim stDocName As String
Dim stLinkCriteria As String

If Me.List3.ListCount > 0 Then
stDocName = "frmClients"
stLinkCriteria = "[ClientID]=" & Me!
[List3]
DoCmd.OpenForm stDocName, , , stLinkCriteria

DoCmd.Close acForm, "frmSearchClient2", acSaveNo
DoCmd.Close acForm, "frmSearchClient1", acSaveNo
Else
DoCmd.Close acForm, "frmSearchClient2", acSaveNo
End If

Exit_Command3_Click:
Exit Sub

Err_Command3_Click:
MsgBox Err.Description
Resume Exit_Command3_Click

End Sub