Hi - sorry if this has been asked before but l cannot find it.
I've just upgraded to Access 2010 and have started to learn to use the navigation forms.
I've created the navigation form and have 2 forms titled Orders and Reports. The orders form has multiple records containing various fields of which one is the Orders_ID which is the primary key.
On the Reports form l wish to have a button which opens an orders report and previews the current record on the Orders form.
In Access 2003 l can reference the current Orders record by using:
DoCmd.OpenReport "Orders_Report", acPreview, , "[Order_ID]=Forms!Orders_Form!Orders_ID"
In Access 2010 this doesn't work and having exhausted all combinations and anything l could find on the net, can anybody help out with the format.
Any advice would be most appreciated.
I've just upgraded to Access 2010 and have started to learn to use the navigation forms.
I've created the navigation form and have 2 forms titled Orders and Reports. The orders form has multiple records containing various fields of which one is the Orders_ID which is the primary key.
On the Reports form l wish to have a button which opens an orders report and previews the current record on the Orders form.
In Access 2003 l can reference the current Orders record by using:
DoCmd.OpenReport "Orders_Report", acPreview, , "[Order_ID]=Forms!Orders_Form!Orders_ID"
In Access 2010 this doesn't work and having exhausted all combinations and anything l could find on the net, can anybody help out with the format.
Any advice would be most appreciated.
