>>>>I thought it worked perfectly but it only prints the first record from
>>>> the
>>>>table. I put "goto bott" before the report form but it
>>>>still only prints the first record in the table. Is there a
>>>>way to pass the information displayed on the form from that field to
>>>>the report?
>>>
>>>You shouldn't issue GO TOP/BOTTOM. 'NEXT 1' clause means current record.
>>>What you have to do is SELECT the table from where you want to print a
>>>record.
>>>
>>>
>>>
>>
>>I agree however when the report is printed the current record shown
>>on the form is not where the record pointer is when the report form
>>is issued or the report always start at the first record. If no
>>parameters are give to the report form all records are printed. It
>>always goes to the start of the table. As a test I issued "goto bott"
>>to see if I would get different results. But it didn't work. I think
>>I need a way to pass the contents of the "week" variable that is
>>shown on the form into the report. Or maybe there is a better way.
>>
>>Any Ideas??
>>
>>
>
>Andy, check the data environment of the report. If your table is in the
>DE, remove it. Then the report will check to see if the table was open
>before the report ran, and the pointer will be at the correct record.
>
>HTH
>Barbara
>
>
Bingo Barbara you had the magic bullet to slay the dragon. Removing
the table from the data envirnoment worked great. Now
REPORT FORM NEXT 1....... works
Thanks
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement