wgraphics
asked on
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!
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!
ASKER
mx-
No expression in the control source. Just the ReorderPoint field taken from a table.
(Table consists of: Inventory#, Date, Price, ReorderPoint)
No expression in the control source. Just the ReorderPoint field taken from a table.
(Table consists of: Inventory#, Date, Price, ReorderPoint)
OK. So then you should be able to overwrite by typing in a value, if that is what you mean ?
mx
mx
ASKER
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-
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-
"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
OK. So, what is preventing that from happening ?
Is the field Locked and/or Disabled ?
mx
ASKER
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.
In the (form) text box properties the "Enabled" says Yes and the "Locked" says No.
Is there anything in the Control Source property for that Control?
Can you update other fields on the form ok?
mx
Can you update other fields on the form ok?
mx
ASKER
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.
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.
"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
Is the AllowEdits property set to Yes?
Is the Form Recordsource a Table or Query ?
mx
Capture1.gif
ASKER
AllowEdits is Yes
Record Source is a query
Record Source is a query
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"possible because is more than one table ?"
>possibly because there is more than one table ...
typos
mx
>possibly because there is more than one table ...
typos
mx
ASKER
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.
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.
You are welcome.
Except for some very special cases, a Form's RecordSource s/b based on a single table/query.
mx
Except for some very special cases, a Form's RecordSource s/b based on a single table/query.
mx
How is this field populated ?
mx