Recent content by mike60smart

Hi If I create a Form which allows you to select a Tag what data would you then want to be able to add? The attached screenshot allows me to select a Tag, and then add details about a specific Level Transmitter and Pressure Transducer associated with the Tag selected.

From the Relationship diagram it is difficult to determine what in fact you need to do. Do you want to be able to Select a Tag and then enter details of the Pressure Transducer as well as details of the Level Transmitter?

Are you able to upload a copy of your actual database?

Hi So all 3 rows belong to 1 peice of Machinary?

Have you an example in Excel of 1 Piece of machinery with all associated Parts?

Hi Are you able to upload a screenshot of your table relationships?

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

This just confirms that your table structure is all wrong.

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.

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

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"

Can you upload a screenshot of your Form in Design View?

Attached is the screenshot of your tables. I do not see a table named "RDCMaterialT" ??

So each of the Controls are Unbound and you have specific VBA Events for specific Controls.

Why have you got the label "Enter" alongside each of your Controls?