I been trying to show a payment method on a report, but I'm having a problem. Is this the correct statement. =DLookUp(" [PaymentMethodID]","Payments","[Payment MethodID]"="Form![Payments]![PaymentMethodID]")
DLook up on a form will only work if the form is open, if it is open when you print your report you don't need dlookup, is your report based on a query?
I've got a combo box on a form with 5 payment methods in its list. I've placed a textbox on a report that needs to list the payment method that was selected from the form before it was closed. I've managed to get the PaymentMethodID but not the actual text. I've used the following in the Control Source. =DLookUp "[PaymentMethodID]","Payments")
If I change the PaymentMethodID to PaymentMethod nothing shows up. Payments is the Form.