Entering text into a table via a query

[mike60smart]

Shouldn't that be Paid ?

Hi Gasman
Yes "Paid" would also be included but difficult to determine as we have no idea of the actual table structure.

 

[turniporange23]

So the Subform for entering Invoice Number information must be based on a query based on Multiple Tables.

The Subform has Multiple Redundant Controls because all you actually need to enter in the Subform is the "Date", "Invoice Number" & "Amount"

They are just optional data if you want to enter into [Mode of Payment] or [Amount] of that invoice, Just wanted to have a PAID label on Invice if paid so if at any stage client wanted a copy of old Invoice it would have PAID written on it
Thanks Bob

 

[mike60smart]

They are just optional data if you want to enter into [Mode of Payment] or [Amount] of that invoice, Just wanted to have a PAID label on Invice if paid so if at any stage client wanted a copy of old Invoice it would have PAID written on it
Thanks Bob

Hi Bob
Well Gasman gave you the solution as to how you can achieve this.
All I am trying to do is point out that the structure of the Subform is wrong.

 

[turniporange23]

Hi Gasman
Yes "Paid" would also be included but difficult to determine as we have no idea of the actual table structure.

Just 2 tables
tblInvoice
tblAccountStatus
which both have a ClientID to connect them in a query, Tables are not linked

 

[turniporange23]

Trouble is Client may have 6 Invoices and may only pay say half the owing amount
Just wanted to get a paid label on invoices manually Thanks Bob

 

[mike60smart]

Trouble is Client may have 6 Invoices and may only pay say half the owing amount
Just wanted to get a paid label on invoices manually Thanks Bob

This just confirms that your table structure is all wrong.

 

[mike60smart]

Can you upload a copy of the database with no confidential data?