Recent content by geoffreyp

Got it working. Placed the control name Me.ContactDetails for the expression for select case and hey presto, it functions as it should. The DisplayWhen Property will hide/show all contents where as I only wanted to show SOME of the contents at appropriate times. Thanks to all Till next time...

Currently I have the event(although not operable) in the reports On Format event since that is where the details will show up. Is that correct? or do I go with your suggestion of placing the event in BOTH of the places you suggest? thanks in anticipation

Thanks for your reply, yes the Option group is bound to a control in an underlying table.

I have an option group on a form which gives choices about whether a persons contact details are available to be printed out(on a report). I need assistance with two areas. Do I need to store the value of the option group in a table for later use or can I simply access the value from the...

Thanks Mr B, that has given me heaps to work with and many thanks for "tidying up" my attempts at code. Geoff

not sure what you mean adam, sorry, can you possibly elaborate?

Hi Adam, sorry not sure what you mean. How should i post code that i have used?

Scenario: I have a form that 1. USER makes a selection & 2 based on that selection(using a option group) a report is generated. I have used code to make the 2nd bit occur but the i want to cover the scenario when a user DOESNT make the first selection but makes the second selection and gets an...

Thanks for your help, i have got it work with the direction you have given me and of course, much playing around till it DOES work. cheers :):)

Is it possible to use a form to select criteria for a query? I have tried putting =[forms]![fExhibitionSelect]![ExhibitionSelect] into the criteria with the result of being asked for a parmeter valu of the same name ie. =forms !fExhibitionSelect !ExhibitionSelect I have also tried putting in...

Thanks Paul, it's been working all the time and I've been driving myself nuts(plus distracting others) trying different things, ah so simple! Onto the next challenge! Many thanks!

Sorry for the lack detail here. I am Using access 07 & the code is running in a report to prevent artist address details from being printed in the catalogue if that is what they have selected. Thanks to all so far :o

I am creating an art exhibition catalogue. I have a form which i have a check box[ContactDetails] for showing/not an artists contact details. I have tried the following code in the "On format" and "On Print" events without any luck. Anyone able to give me some direction here?:o Private Sub...