Default values in filtered forms

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • HERNDON
    New Member
    • May 2007
    • 7
    #1

    Default values in filtered forms

    Hello all. I am not really good at explaining my issues, however i hope you can help me.

    I am trying to set a default value in a field i have named Resource Type on my Resource form. This form has been filtered so when a program selection is made, only the programs for the resource 'type' may be entered. (ie: all self help programs in the self help program type form; all prosocial programs in the prosocial type form). I would like the Resource Type field to be a data entry free field and also to show as the default on any and all new records for that form. I know this is possible, however, i can not figure out how to set the properties for this.

    I have set the Default Value as Self Help, however, i recieve an error message which states as follows:
    The expression you entered contains invalid syntax.

    I have also locked this field so as to not enter data and the Tab Stop option has been set at 'No.'

    Not sure what else i can do to make this work. I am not completely great at Visual Basic and the little i do know, i taught myself. Please Help. Thanks a bunch! :)
    Tags: None
    • mlcampeau
      Recognized Expert Contributor
      • Jul 2007
      • 296
      #2
      Did you try setting the Default Value to "Self Help" with the quotations?

        Comment

        • FishVal
          Recognized Expert Specialist
          • Jun 2007
          • 2656
          #3
          You definitely should take a look at this thread
          Add Matching Record on Filtered Form

            Comment

            • HERNDON
              New Member
              • May 2007
              • 7
              #4
              Originally posted by mlcampeau
              Did you try setting the Default Value to "Self Help" with the quotations?

              Yes, i did try this and i also locked the field so that it may not be entered. It is just not working. Should i have made the default on the table record and the form control? If so, i made that attempt as well. For some reason, it is not enough.

              thank you so much for taking an interest though. I need all the help i can get with this before i throw the computer out! :) hahaha.

                Comment

                • HERNDON
                  New Member
                  • May 2007
                  • 7
                  #5
                  Originally posted by FishVal
                  You definitely should take a look at this thread
                  Add Matching Record on Filtered Form

                  Thank you so much. I have reviewed all of the postings on this thread and it looks like it will be able to help. I am going to run some of the coding listed and see if it works for my situation. I will be in touch...soon! :)

                    Comment

                    • NeoPa
                      Recognized Expert Moderator MVP
                      • Oct 2006
                      • 32669
                      #6
                      Registering in case you have any questions on the code in that linked thread.
                      They should be posted in here if you do and I will try to answer it if you do.

                        Comment

                        Previous template Next
                        Working...