I have a form that i need to display a record on open.
This record is from a table with a column "ID" There maybe duplicate ID numbers but i need the code to find the ID and if the "servicecode" field has certain text ("Discount" for instance) then to show that record. I tried the following but I have got something wrong as it does not search for the combination.
If invs!ID = Forms!InvoiceAlterView!InvoicedetailsAlterView.Form!invdetailID And Left(invs!servicecode, 10) = "Discounted" Then
Have I explained this....????