Subform not displaying all fields - Pls help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form and two subforms. Everything seems to work fine except
for a field that is in the main form and same field in subform. When I type
in this text field it should show up on my second subform. It does display
on the first and second records. But if there are more, the text will not be
displayed. I have checked everything out but can't fix. Can someone please
tell me what I am doing wrong? Thank you. Appreciate any help.
 
. Can someone please
tell me what I am doing wrong?

No, because you haven't told us what you're doing. Please post your code and
the Recordsources of the forms.

John W. Vinson [MVP]
 
Record Sources of the forms are:

Main form - query
subform - query
subsubform-query

childlink - RCDID
MasterLink - RCDID

Private Sub COMMENTS_AfterUpdate()
Me.PROVIDER_list.Requery
End Sub

I have this after update code in the textbox afterupdate. Hope this helps
to provide some answers Thank you.
 
Record Sources of the forms are:

Main form - query
subform - query
subsubform-query

Please open the Queries in SQL view and post the SQL here.
childlink - RCDID
MasterLink - RCDID

That's for one subform. What about the other subform?
Private Sub COMMENTS_AfterUpdate()
Me.PROVIDER_list.Requery
End Sub

and PROVIDER_list is the name of... what?
I have this after update code in the textbox afterupdate. Hope this helps
to provide some answers Thank you.

It's a good start... keep 'em coming...

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top