How to clear form fields on loading?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • goumeziane
    New Member
    • Jul 2008
    • 2

    How to clear form fields on loading?

    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.
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Originally posted by guomeziane
    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.

    List of reasons why a Microsoft Access query will yield non-editable results.


    Welcome to Bytes!

    Linq ;0)>

    Comment

    • goumeziane
      New Member
      • Jul 2008
      • 2

      #3
      Originally posted by missinglinq
      .

      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.

      List of reasons why a Microsoft Access query will yield non-editable results.


      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.

      Comment

      Working...