By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Default values in filtered forms

P: 7
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! :)
Sep 19 '07 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 296
Did you try setting the Default Value to "Self Help" with the quotations?
Sep 19 '07 #2

FishVal
Expert 2.5K+
P: 2,653
You definitely should take a look at this thread
Add Matching Record on Filtered Form
Sep 19 '07 #3

P: 7
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.
Sep 20 '07 #4

P: 7
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! :)
Sep 20 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
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.
Sep 20 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.