Record report help

[gebmiller1984]

Hi I have created a form where data is inputted from another table. I enter Invoice amounts etc in this table. Click to preview a invoice. Works perfect. What I want to add to this is 3 tick boxes. all three are different terms and conditions. What I want help with is how to add this to the current record print setup so that when a particular box is ticked whether is Terms and Conditions A, B or C it will add the particular one to the invoice. Any help would be appreciated.



Thanks

[June7]

The invoice is a report object?

Don't you want this condition indicator saved with the invoice record? That would be the easiest approach. Save condition indicator (1, 2, 3 would be easier than A, B, C) into record. Then calculation on report can display the appropriate text based on value in field. How long is this text?

Could also have a TermsConditions table with 3 records. Join this table to the data table in report RecordSource and bind textbox to the descriptive text field.

[gebmiller1984]

Prob about 20 words. May try the Table idea as then I can change at a later date easier. Thanks

[June7]

Suggest you use radio buttons in an option group and save 1,2,3 - if you go this route and still want A, B, C will need code.

Or use a combobox with 3 choices then can easily save A,B,C. The combobox can use table as source for the list.

[gebmiller1984]

I have tried the Table route but What I want it wont work for. Any examples of how I could do this from selecting a tick box idea out of 3. Coding??

[June7]

Why won't table work?

Are you saving the condition ID into the invoice record? If saving 1,2,3, expression in textbox on report could be like:

=Choose([Condition], "this text", "other text", "another text")

[gebmiller1984]

The amount I need is too long. Could I use a memo box. Also I cant seem to make things work. May be just what Im doing. Could you send me a bit of some instructions on how to do it. Thanks

[June7]

If the text lengths are too long for expression in textbox, will have to use a table with memo field.

Rather see what you attempted. If you want to provide db for analysis, follow instructions at bottom of my post.