Hello Peter:  Do you have the child and master fields chosen on the property sheet of the subform?

Hi Helen,  Yes the master and child fields are selected, and it works fine until I start the search routine, then the data disappears

Hello Peter:  I think you have to requery the subform then.  On the form properties, put VBA code in the "On Current" event to refresh the subform.  For example:  
Private Sub Form_Current ()
  [subform name]. requery
End Sub

Hi Peter,

Reset the Record Source of your Subform in both the button and the OnCurrent event.

SubformName.Form.RecordSource = "SELECT * FROM TableName WHERE ID=" & ID

Replace SubformName, TableName and ID with the names of your objects/fields.

@Helen there's no query involved here.

@Kevin : I get compile error,   variable not defined, see screenshot

What is the NAME of the subform control itself? I'll bet you have it spelled wrong or it's something else.

The name is KenmerkF, I did not misspell

To add to what Kevin suggested,, I have two suggestions:
1) change the Where part of his code to:
ID = '" & ID & "'"  (Since it is hard to see...it is as follows with no spaces ...ID  '  " & ID & "  '  ")

2) add "Form" to the beginning of the code that Kevin suggested.

How do you insert images in these posts?  I tried, but couldn't.  

Image Uploads Helen

Where exactly is that code? Make sure it's in the right form module.

Thats the one Richard! At first I put the (Kevins) code in the subform, but it should be in the main form!
It works fine now! And it looks like it's not necessary to also add the code to the search button.
Thanks all for the help!

That's great Peter. One thing I should mention is you should wrap the code in an If block otherwise you will get an error on new records.

If Not IsNull(ID) Then
   ' code goes here
End if

Tnx Kevin, I added the extra code

This is one of those things that you can solve in 2 seconds if you can see the whole database. LOL

This problem has always been an issue for me too.  I don't understand why there is a vba requery for a form, but it rarely works. I don't know if it is the queries / tables in the forms that is stopping it from being requeried? Also, why does Kevin's vba work for Peter, but not for me?    Something is not working somewhere.  Also based on Google searches it is a wide spread issue, that is not always fixed.   Would you please add this to your list of videos to make, Richard?