Putting Report Results IN A Form

[alexi]

HELP!

I have been stuck on this one for a couple of weeks now guys, can anyone help with some ideas?
I create an invoice report from some specs which i select on a form. This generates the invoice report once. However i want to be able to edit the data and save the data on this invoice. So what i need to do is transfer the information from the report into a form in datasheet view, based on an invoice number. This way i can edit anything i need to, it will be saved, and then i can report on that information print it out and send it off.

Any ideas?

Ta
Alexi

 

[alexi]

ok i will try that, but is there a way of moving the info fro a report to a form?

 

[alexi]

ok, thanks for this by the way.

i have tried this before,

open report
report!control.name = forms!control!name
close report

this gives a random line from the report over to the form.
anyway of getting them all across using this method? like a loop or somethin?

 

[alexi]

i dont suppose you could give me a bit of example code for this? im having trouble finding any?

 

[alexi]

ok ive done what pat suggested in the first reply by creating some tables and appending to them. this works ok, however the query shows every entry from the timesheets, so each time a task is worked on it shows it, what i want though is a sum of all the hours etc under one task, not every time it shows up in the timesheet.
any ideas?

 

[alexi]

ive just tried that but which should i change to a sum to get it to do what i want?

 

[alexi]

there is 3 that are calculating things off the tables. these are expressions not sums but same thing yeah? but each of these is attached to an entry (by a taskID). so i dont want each time a taskID is entered to show up, but the totals for each task and everything under that.?