How to Overwrite a field on an Access form

Hello-
Is it possible to overwrite a field on an Access (2002) form?

We have a form that had various fields. One of the fields is Re-Order Qty.

The Re-order qty field automatically populates. For example, enter an Inventory# 655 and up pops the Re-Order Qty of 2000.
There are times when we do not want to order 2000 of that item, so we would like to select the 2000 and change it to a different qty.

Is there a simply solution to make that sort of edit on the form?
Thanks!
wgraphicsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Is the Control Source property for that text box a Calculated control .. ie has an Expression in the Control Source ?

How is this field populated ?

mx
0
wgraphicsAuthor Commented:
mx-
No expression in the control source. Just the ReorderPoint field taken from a table.
(Table consists of: Inventory#, Date, Price, ReorderPoint)

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
OK.  So then you should be able to overwrite by typing in a value, if that is what you mean ?
mx
0
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

wgraphicsAuthor Commented:
Yes. It should be as easy as pie, I just can't get it.
When I built it all I did was drop the ReorderPoint field into the form. When user open form and sees they do not like that number, I want them to be able to click the field and type over it.
Thanks-
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"I want them to be able to click the field and type over it."
OK.  So, what is preventing that from happening ?
Is the field Locked and/or Disabled ?

mx
0
wgraphicsAuthor Commented:
You are correct- it is like it is locked- it doesn't let you do anything.
In the (form) text box properties the "Enabled" says Yes and the "Locked" says No.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Is there anything in the Control Source property for that Control?

Can you update other fields on the form ok?

mx
0
wgraphicsAuthor Commented:
The field name ReorderPoint is the only thing in the Control Source.
When I take ithe the fieldname out of there it becomes unbound and blank.

The other fields just show info and do not need to be updated. I tried it for the heck of it though, and no, they do not allow me to update.

I thought maybe something in the table (or the field in the table)was preventing me from making edits but haven't figured it out yet.

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"and no, they do not allow me to update."
Is the AllowEdits property set to Yes?
Is the Form Recordsource a Table or Query ?

mx
Capture1.gif
0
wgraphicsAuthor Commented:
AllowEdits is Yes
Record Source is a query
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
ok ... then the Query itself is not updatable ... possible because is more than one table ?

Can you test the query by itself ?

If not, upload a sanitized version of the db so I can look at it ...

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"possible because is more than one table ?"
>possibly because there is more than one table ...

typos

mx
0
wgraphicsAuthor Commented:
mx,

The query contains 2 tables. One the table mentioned above (very simple table) and the other table is a table built from other tables.

Even though my field is in a simple table, that table is attached to a few others- most likely making it not updatable- just as you said.
I am going to close this thread because I think I may have to try to build the form off of the "simple table" or think of an alternative.
Thank you so much for your help.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
You are welcome.
Except for some very special cases, a Form's RecordSource s/b based on a single table/query.

mx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.