By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

Updating Data from a form

P: n/a
I have created a input form that enters a number in a talble. If I
open the form again it enters a new record instead of editing the
existing record. It seems like it should be very basic but I see no
way to do it other than a complicated macro.

Aug 15 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Open your form in design view.
Open the Properties box (View menu.)
On the Data tab of the Properties box, set the Data Entry property to No.

Data Entry is for entering new records each time you open the form. Setting
it to No shows existing records.

(If you can't see the property, you are looking at the properties of a text
box instead of the properties of the form.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brian Blair" <ag*****@shaw.cawrote in message
news:r5********************************@4ax.com...
>I have created a input form that enters a number in a talble. If I
open the form again it enters a new record instead of editing the
existing record. It seems like it should be very basic but I see no
way to do it other than a complicated macro.

Aug 15 '06 #2

P: n/a
"Brian Blair" <ag*****@shaw.cawrote in message
news:r5********************************@4ax.com...
>I have created a input form that enters a number in a talble. If I
open the form again it enters a new record instead of editing the
existing record. It seems like it should be very basic but I see no
way to do it other than a complicated macro.
Open your form in design mode and set the "data entry" property to "no".

Keith.
www.keithwilby.com
Aug 15 '06 #3

P: n/a
The only thing this changes is what is displyed. It does not change
how the form modifies the table. I want it to replace the existing
number in the table. Not add an additional entry each time you enter a
number on the form.

On Tue, 15 Aug 2006 08:58:48 +0100, "Keith Wilby" <he**@there.com>
wrote:
>"Brian Blair" <ag*****@shaw.cawrote in message
news:r5********************************@4ax.com.. .
>>I have created a input form that enters a number in a talble. If I
open the form again it enters a new record instead of editing the
existing record. It seems like it should be very basic but I see no
way to do it other than a complicated macro.

Open your form in design mode and set the "data entry" property to "no".

Keith.
www.keithwilby.com
Aug 15 '06 #4

P: n/a
"Brian Blair" <ag*****@shaw.cawrote in message
news:s0********************************@4ax.com...
The only thing this changes is what is displyed. It does not change
how the form modifies the table. I want it to replace the existing
number in the table. Not add an additional entry each time you enter a
number on the form.
More info required. What do you mean by "existing number in the table"?
Remember, we can't see your design.

Keith.
Aug 15 '06 #5

P: n/a

"Brian Blair" <ag*****@shaw.cawrote in message
news:s0********************************@4ax.com...
The only thing this changes is what is displyed. It does not change
how the form modifies the table. I want it to replace the existing
number in the table. Not add an additional entry each time you enter a
number on the form.
Sounds almost as if your updates / writes to the Table are being done not by
the bound Form, but from VBA code that executes. That's the only way I can
figure why "only thing this changes is what is displayed" not "how the form
modifies the table." Because certainly, a bound Form with Data Entry set to
No, and Allow Edits set to Yes _does indeed_ change "how the form modifies
the table," unless something has been done to "interfere" with the normal
workings of bound forms.

Larry Linson
Microsoft Access MVP
Aug 15 '06 #6

P: n/a
The form is a bound form to a table. The intent is to have only one
number in the table. It would function in the same manor as a query
input. The problem I have is that I have queries that use the same
input in the query as well as the sub query. You are prompted twice
for the same number. I want to enter the number from a form to a table
and have all the queries run from this number in the table.

When I open the form it opens to the last entry with the entry
highlighted. If I simply enter another number then it creates a new
entry. If I hit delete first then it replaces the entry. Is it
possible to eliminate the nessessity to hit delete first to get it to
modify the entry instead of create a new one.

On Tue, 15 Aug 2006 16:16:20 GMT, "Larry Linson"
<bo*****@localhost.notwrote:
>
"Brian Blair" <ag*****@shaw.cawrote in message
news:s0********************************@4ax.com.. .
>The only thing this changes is what is displyed. It does not change
how the form modifies the table. I want it to replace the existing
number in the table. Not add an additional entry each time you enter a
number on the form.

Sounds almost as if your updates / writes to the Table are being done not by
the bound Form, but from VBA code that executes. That's the only way I can
figure why "only thing this changes is what is displayed" not "how the form
modifies the table." Because certainly, a bound Form with Data Entry set to
No, and Allow Edits set to Yes _does indeed_ change "how the form modifies
the table," unless something has been done to "interfere" with the normal
workings of bound forms.

Larry Linson
Microsoft Access MVP
Aug 15 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.