how to update a table with a form in ADP?

[Allen_N]

I'm using a single-row table to store execution parameters for code in an
Access Project. However, I can't actually update the fields in the table
this way; changing the bound text boxes in the form causes a new record to be
added to the table, instead of updating the existing one.

I thought I could get the behaviour I want by setting the 'Data' properties
of the form, namely:

'Allow Additions' = False
'Allow Edits' = True
'Data Entry' = True.

However, the 1st setting causes the form to go blank, and then no changes
can be made (directly or in code) to any controls. Access Help on this topic
is incredibly brief and uninformative, so I wouldn't be surprised to learn
that I completely misunderstand what they are for.

Could anyone advise me?

Thanks!

 

['69 Camaro]

Hi, Allen.

'Data Entry' = True.

When the DataEntry Property is set to true, it means "I only want to use
this form for data entry of new records. I don't care how many other rows
are in the table. I only want to see the new row I am creating."

Try setting the DataEntry Property to false if you want to see existing
rows.

 

['69 Camaro]

Hi, Allen.

'Data Entry' = True.

When the DataEntry Property is set to true, it means "I only want to use
this form for data entry of new records. I don't care how many other rows
are in the table. I only want to see the new row I am creating."

Try setting the DataEntry Property to false if you want to see existing
rows.

Access Help on this topic
is incredibly brief and uninformative

Access is one of those development tools that requires experience, not just
book learning, because there are so many pitfalls to learn how to sidestep.
The DataEntry Property is one of them.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Allen_N]

Thanks, Gunny.

No argument here!

Hi, Allen.


When the DataEntry Property is set to true, it means "I only want to use
this form for data entry of new records. I don't care how many other rows
are in the table. I only want to see the new row I am creating."

Try setting the DataEntry Property to false if you want to see existing
rows.


Access is one of those development tools that requires experience, not just
book learning, because there are so many pitfalls to learn how to sidestep.
The DataEntry Property is one of them.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.