Update Query?

[Benn]

Hello,

I am having a little trouble using an update query. I think it's an update query that I should be using but I may be wrong. (If anybody could guide me in the right direction if this is the case I would appreciate that)

I have a text box on a form which contains a numerical value. The object is called "Text1".

It is on a form called "Form1"

I create a new query (an update query) and add the field that I want to update and add the following..

Update To: [Forms]![Form1]![Text1]

Now to me, logically that should work. It should update the field I added to the query with the value in the text box "Text1" from the form "Form1".

Any help is much appreciated.

 

[jdraw]

Hello,

I am having a little trouble using an update query. I think it's an update query that I should be using but I may be wrong. (If anybody could guide me in the right direction if this is the case I would appreciate that)

I have a text box on a form which contains a numerical value. The object is called "Text1".

It is on a form called "Form1"

I create a new query (an update query) and add the field that I want to update and add the following..

Update To: [Forms]![Form1]![Text1]

Now to me, logically that should work. It should update the field I added to the query with the value in the text box "Text1" from the form "Form1".

Any help is much appreciated.

On your form Form1, you have a textbox Text1 that contains a numeric value. And you want to increase the value of Text1?
Me.text1 = text1 + Incremental value

Where do you get the data for your form?

I don't understand why you think this is an Update query.
Perhaps you could provide more detail and even an example.

 

[Benn]

Hi,

Text1 is a text box on a form which contains a numerical value.

I want to then update or change a field in a table to the value in Text1.

For example -

Text1 contains the total quantity of items purchased. So Text1 could equal "15".

There is then a field on the customer table called "NumberPurchased" which I then want to update to the number contained in Text1.

Hope this clarifies some things,

Thanks.
Benn.