Search results

so its name conflict. why when I select name does it return the name of the report. Is that because "Name" is a reserved word?

Hi bob, Thanks I'll keep that sample in case I need it in the future. I've created a really simple demo. Basically open form1, go to tab 2 then choose a radio button, click "run report" the report should either show the id or the name field from tbltest. Instead you get #Error

Paul the form is open when the report is run. unfortunately I cannot post the db as it does contain sensitive data, but I'll try and create a dummy db and see if it works or post it here.

Paul - I have a tab control setup on my form and the option group has been placed on one tab. Bob - No they dont have nulls

Hi Paul, Thanks for your help. Unfortunately its still returning #Error in my report Is there another way to set the controlsource other than using IIF().

Option16 is one on the radio buttons what do I use to obtain the optiongroups value? My option groups name is optGroupView

Hi In one of my fields in my report I have the the control source set as follows: =IIf(Forms!frm_standing_order_report!Option16.OptionValue=1,[bank_statement_date],[data_for]) Its returns #Error. I have an optiongroup that has radio buttons this is placed on a tab within one of my forms. If...

still cant get it to work. Can anybody help me?

Hi David, I need some help how do I reference this radio button/option group's value? I have a form that has tabs. On one of the tabs there is this option group which contains the radio buttons. control source = iif(button = 2 , bank_statement_date,data_for)

not only reports but forms,lables,textbox,comboboxes etc. Like on print, on retreat, on click, on change, before update etc.

thanks I'll try that what about my second question on where to find out about events?

Hi, I have a form that has a radio button on. What I want to do is change the data source for a particular column of my report based on the radio buttons value. eg. radio button has two option "show col1" or "show col3" my report is as follows Col1 | col2 If the user has selected "show...

Thanks both of you. I'm now getting the effect I was after.

thanks for both the options. wheres the best place to initialise the docmd/.addnew to goto the new record?

Hi, I have a form with tabs and each tab contains a subform. How can I set this subform to start with a new record?

Spot on. thanks a million.

Hi My report is working perfectly except when it start getting to the bottom of the page the group header seems to print the header and then the data onto the next page which is a bit point as I would like the header to be on the same page as the data. Any idea how I can sort this on out?

Many thanks that worked perfectly.

Hi, I have a column report i.e in my detail section I have Col1 | Col2 | Col3 Comments: Comments value I've report is perfect and I have now added the comments into the report but it not giving me the results I was hoping for. I wanted to only expand the details section and show the...

Bump bump bump....