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

How to clear form fields on loading?

P: 2
Hello,
I am new on this forum and I thank you all of you for your help already.
I know this question has been asked already, but the answer did not worked for me. To change the Property 'DataEntry' to YES, is not working. My query which is teh main record sets of my form always fills all the fields in my form with the first item of the select result. How can I tell the form to start with all its fields blank?
thank you.
Jul 10 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
To change the Property 'DataEntry' to YES, is not working
.

This is perplexing, to say the least. If the form is a bound form, setting Data Entry to Yes should, indeed, cause your form to open with a new, blank record showing. My only guess is that the query which your form is based on is a Read-Only query. If the query is read only, no new record can be added. To see if this is the case, from the Objects Dialog box go to Queries and click on the query that your form is based on to open it. Now try to enter a new record directly into the query. If you're unable to do so, this is the cause of your problem.

If this is the problem, follow this link to Allen Browne’s article explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Welcome to Bytes!

Linq ;0)>
Jul 11 '08 #2

P: 2
.

This is perplexing, to say the least. If the form is a bound form, setting Data Entry to Yes should, indeed, cause your form to open with a new, blank record showing. My only guess is that the query which your form is based on is a Read-Only query. If the query is read only, no new record can be added. To see if this is the case, from the Objects Dialog box go to Queries and click on the query that your form is based on to open it. Now try to enter a new record directly into the query. If you're unable to do so, this is the cause of your problem.

If this is the problem, follow this link to Allen Browne’s article explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Welcome to Bytes!

Linq ;0)>

Hello, thank you for your answer and welcome. In fact no, my query is not a Read-Only one. I do not understand what is happening here.
Jul 11 '08 #3

Post your reply

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