How i copy data from query field to another unbound text box (1 Viewer)

tempaccount

New member
Local time
Today, 23:29
Joined
May 24, 2021
Messages
6
I have a master table datasheet form, I need when I click on invoice no it will be open another form (Update Form) & update the unbound text box with the same data which i click on data sheet.

Also need update the unbound note text box data into master table in same invoice no.

is it possible, please help.
 

Attachments

  • Database1.accdb
    800 KB · Views: 383

Jon

Access World Site Owner
Staff member
Local time
Today, 17:59
Joined
Sep 28, 1999
Messages
7,304
Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:59
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!

I have moved your topic out of the Introduction forum. You can still post an introduction in that forum if you like.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 10:59
Joined
Aug 30, 2003
Messages
36,118
DoCmd.OpenForm "Update"
Forms!Update.text2 = Me.Invoice_No

FYI, I'm going to move your thread out of the introductions forum.
 

jdraw

Super Moderator
Staff member
Local time
Today, 13:59
Joined
Jan 23, 2006
Messages
15,364
Welcome.
Your query (also the recordsource of your form) is a GROUP query. What totals do you want to put in the Notes column of which record?? More clarification needed.
 

tempaccount

New member
Local time
Today, 23:29
Joined
May 24, 2021
Messages
6
I need help as per attached diagram.
 

Attachments

  • I need help as shown as diagram.pdf
    79.9 KB · Views: 366

tempaccount

New member
Local time
Today, 23:29
Joined
May 24, 2021
Messages
6
Welcome.
Your query (also the recordsource of your form) is a GROUP query. What totals do you want to put in the Notes column of which record?? More clarification needed.
I need help as per attached diagram
 

Attachments

  • I need help as shown as diagram.pdf
    79.9 KB · Views: 391

jdraw

Super Moderator
Staff member
Local time
Today, 13:59
Joined
Jan 23, 2006
Messages
15,364
There are 2 records in your table with that invoice number. How do you decide which of those records should be updated with the Note?

For invoice 2092100002, there are 8 records --which should get the Note and why/how is it determined?
 

tempaccount

New member
Local time
Today, 23:29
Joined
May 24, 2021
Messages
6
Notes will be update all notes field where invoice no 2092100002 is present
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:59
Joined
Feb 19, 2002
Messages
42,971
Why is the note being stored MULTIPLE times in the master table when it could be stored ONCE in the invoice table? Looks like your table design is incorrect.
 

jdraw

Super Moderator
Staff member
Local time
Today, 13:59
Joined
Jan 23, 2006
Messages
15,364
In your proposed set up you'll repeat a value for each record. Perhaps there should be another, related table to keep a history of Notes for the invoice number, not the specific detailed records.
update:
I see Pat has answered, and agree, storing the Note once is most appropriate.
 

tempaccount

New member
Local time
Today, 23:29
Joined
May 24, 2021
Messages
6
Ok, how is it possible, Also help how i store temporary data in [copy invoice field] as shown as pdf
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:59
Joined
Feb 19, 2002
Messages
42,971
We need to understand why you can't store the note with the invoice in order to help with a solution. It is really poor practice to store the same piece of data in multiple places. Also, is it possible to save multiple notes for the same invoice?
 

Users who are viewing this thread

Top Bottom