newbie,filter not printing the current record

V

verci

Hi, Factura means Invoice in spanish, now plase have patince

I got the master table Factura trough the field FacturaID in a one to
many relationship to the FacturaID field in the details table
FacturaDetalle, now I've created a form frmFactura that has a child
form linked frmFacturaSubform, I've added a command button to print the
invoice wich opens a report Factura, on the reports properties Record
Source I've place the following:

SELECT Factura.FacturaID AS Factura_FacturaID, FacturaDetalle.FacturaID AS
FacturaDetalle_FacturaID, FacturaDetalle.Cantidad, FacturaDetalle.Unidad,
FacturaDetalle.Descripcion, FacturaDetalle.Punitario,
FacturaDetalle.Importe, Factura.Nombre, Factura.Direccion, Factura.Ciudad,
Factura.RFC, Factura.CantLetra, Factura.FechFactura, Factura.Retencion FROM
Factura INNER JOIN FacturaDetalle ON
Factura.FacturaID=FacturaDetalle.FacturaID;


and on the filter property:

([Factura_FacturaID] = Forms![Factura]![FacturaDetalle
Subform].form![FacturaID])

The problem is when I print the report always sents a blank page after the
invoice is printed, even tough the first page is printed correctly with the
current record, this happens every time I print a different record.

Any help would be very appreciated, best regards
 
Top