How i copy data from query field to another unbound text box

[tempaccount]

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.

 

[Jon]

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]

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]

DoCmd.OpenForm "Update"
Forms!Update.text2 = Me.Invoice_No

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

 

[jdraw]

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]

I need help as per attached diagram.

 

[tempaccount]

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

 

[jdraw]

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]

Notes will be update all notes field where invoice no 2092100002 is present

 

[Pat Hartman]

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]

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]

Ok, how is it possible, Also help how i store temporary data in [copy invoice field] as shown as pdf

 

[Pat Hartman]

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?

 

[jdraw]

In many situations you would have Customer creates an Order for 1 or many detail items; also an Invoice that could have invoice detail records.
See this model for some typical tables and relationships - some of which may apply to your situation.