Query losing a column in form

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have a form that has a subform which is based on a query, yet when I choose
an option to call another query the form loses the first column of data? I
am not sure as to why? The queries work on their own and when the form is
first opened the data is correct.

Here is my code.
Me.subfrmDMROverview.SourceObject = "query.qryInProcDMR"
Me.subfrmDMROverview.Requery
Me.subfrmDMROverview.LinkChildFields = ""
 
Your last line of code is removing any linking field for the subform's data.
When you set it to an empty string, the subform no longer can be related to
the main form.
 
The form is basically I form with radio buttons that lists different issues
status.
The subform is a datasheet listing an overview of the issues.
When I remove the last line of code nothing appears in the query.
So I am lost as to what to do...
 
Please tell us much more detail about the form and subform -- the queries
(preferably the SQL statements) that you use as the record sources, the
controls that are on the main form (with names), the properties of the
subform control (the control on the main form that holds the subform
object), etc.
 
Back
Top