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?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
OK.  So then you should be able to overwrite by typing in a value, if that is what you mean ?
mx
0
 
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 ArchitectCommented:
"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 ArchitectCommented:
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 ArchitectCommented:
"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 ArchitectCommented:
"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 ArchitectCommented:
You are welcome.
Except for some very special cases, a Form's RecordSource s/b based on a single table/query.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.