From textboxes on form to report ??

[SpookiePower]

I have made a report that shows some info about a custemor,
that I have selected on a form. On this form I also have some
comboboxes and textboxes. I dont know how to get the text
from the comboboxes and textboxes to be showed on the report.

My custemor is in a table and by dropping the fields from the
field-list onto the report, I can show the custemor. But the text
in the comboboxes and textboxes is not saved in a tabel, it is
something I write/choose. How can I get this to be showed on
the report ?

 

[Guest]

in general terms - use this syntax at the correct location on your Report:

Forms![FormName].[TextboxName]

the brackets are not needed if there is no space in the name

this will also work for the selected value of a combobox

 

[SpookiePower]

in general terms - use this syntax at the correct location on your Report:

Forms![FormName].[TextboxName]

the brackets are not needed if there is no space in the name

this will also work for the selected value of a combobox

Thanks. I'll try it later today.

 

[SpookiePower]

It does not seems to work.

I get this errormessage:
Invalid control property - control source
No such field in the field list.

But I'm not using the field list ??

 

[Guest]

the field list is the term for all the names of all fields available on that
form and doesn't intend to imply that you are using a field list.....

anyways.....

this is the generic error message telling you it can't find the object that
you are specifying...

maybe a typo? or do you have the wrong text box name? try another known
textbox...

 

[SpookiePower]

the field list is the term for all the names of all fields available on that
form and doesn't intend to imply that you are using a field list.....

anyways.....

this is the generic error message telling you it can't find the object that
you are specifying...

maybe a typo? or do you have the wrong text box name? try another known
textbox...

I have to write the - Forms![Formname]![Textboxname] - in the controlsource
of the destination textbox ??

Nothing seems to work. I have tryed to get the content of a textbox on one form,
to another form, but I still get the same error.

 

[Guest]

correct.- in the controlsource of the destination Report's textbox

the problem may be that you must leave the form open....don't close the form
- just shrink... otherwise your Report won't be able to find that form's
textbox's value

if the form is open and it isn't working - you need to double check the form
name and text box name....

otherwise - do a real sanity check and create a new form - with one text
box....create a new report with one text box....and make it work - just to
get your bearings on this....and somehow you need to trouble shoot your
existing app...


--
NTC

the field list is the term for all the names of all fields available on that
form and doesn't intend to imply that you are using a field list.....

anyways.....

this is the generic error message telling you it can't find the object that
you are specifying...

maybe a typo? or do you have the wrong text box name? try another known
textbox...

I have to write the - Forms![Formname]![Textboxname] - in the controlsource
of the destination textbox ??

Nothing seems to work. I have tryed to get the content of a textbox on one form,
to another form, but I still get the same error.

 

[SpookiePower]

I forgot the = sign. In all the places I was looking, they did not mention
anything about the = sign.

=Forms![Formname]![Textboxname]