Code Not Changing Report

[dubiousp]

I have moved on amzingly thanks to the support and help from people in this forum, Im struggling with code behind my form. The idea is that data is entered through the basic form, then when form is clicked you can select the name for the report record. For some reason ven though I can select the name the report values do not change

Any help appreciated

 

[pbaldy]

Which report? Which form? How does someone unfamiliar with your app recreate the problem?

 

[Pat Hartman]

When you open a report/form from a form and you expect to see the changed data, you need to save the record BEFORE you open the report/form.

Use
DoCmd.RunCommand acCmdSaveRecord
or
Me.Dirty = False 'force current record to save

 

[arnelgp]

i already create a paramatered form for your report (A4CDM).

 

[dubiousp]

Pat thankyou for pointers

@arnelgp thankyou works a treat enable me to move foeard

 

[dubiousp]

@arnelgp could you point me on how to sync other sub rports to that record, do I need to point the ID of subform to main form

 

[dubiousp]

The main form for data entry is Basic then the report for selection is A4CDM..

I have fiddled with Parent and Child fields but fail to get the correct data to load per paerson

 

[Pat Hartman]

You sync subforms/reports with main forms/reports by using the Master/Child links. Click the control that holds the subform/subreport and open the properties dialog.

 

[dubiousp]

Thanks Pat thats wha I thought but seems not to work as I thought following MS guide... I was basing my thoughts around the foreign key linked to main report ID

 

[dubiousp]

i already create a paramatered form for your report (A4CDM).

Its got me beat tryed all sorts of combinations with master and child.. cannot get sync to work hmm

 

[arnelgp]

review the Record source of each subform.
instead of using Inner Join, use Left Join.

 

[Pat Hartman]

Are you getting errors? Have you included the correct fields in the queries?

Try closing everything and compacting the database.