Newbie,filter not printing the current record

  • Thread starter Thread starter verci
  • Start date Start date
V

verci

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

I got the master table Factura link 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
 
verci said:
Hi, Factura means Invoice in spanish, now plase have patince

I got the master table Factura link 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
Click to expand...

It's a problem of page size. Reduce it


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
Hey taht did it thanks!!!!!!!!!!!!!!!!!!!!!

MA said:
verci said:
Hi, Factura means Invoice in spanish, now plase have patince

I got the master table Factura link 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
Click to expand...

It's a problem of page size. Reduce it


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
Click to expand...
 
Back
Top