Form to Report Help...

[Dre313]

I have a form which searches for records ... When the user hits enter another forms pops up and ask for your name and the company you work for.. The user enters in the information hit ok and the form closes and a report of the records the user ask for pops up with the users name and company on the report.... The users name and company information gets added to a seperate table.. What I want to know is .. is there another way of adding the users name and company to the report without having to store it in a table.. or after the user enters in the information.. to delete whatever information is in the table ?

Each time a user enters in the record they want to see, they have to enter in there name and company.. can be different person each time.. This is for reporting purpose..

any ideas ?

 

[MakeItSo]

If you have it on a form, then just make sure, you do not close the form after the input.
Choose [Forms]![YourInputForm]![Username]
as the data source for the respective textbox on your report.
This works fine. I have done the same for a db analysis report with =[Forms]![Frm_choose_analysis]![criteria] as the data source for a textbox on my report...

Cheers,
makeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[Dre313]

almost fergot you could do that.. thanks