Search results

  1. G

    Option group & select case

    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...
  2. G

    Option group & select case

    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
  3. G

    Option group & select case

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

    Option group & select case

    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...
  5. G

    code for checking control

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

    code for checking control

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

    code for checking control

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

    code for checking control

    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...
  9. G

    selecting query criteria

    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 :):)
  10. G

    selecting query criteria

    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...
  11. G

    check box & code

    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!
  12. G

    check box & code

    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
  13. G

    check box & code

    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...
Back
Top Bottom