Search results

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?

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?

Hi Bob Are you able yo upload a copy of your database?

In your tables what data type are the fields "Connector ID" and "Pin ID"?

OK Don't know if the following would help, would changing this line of Code:- If Me.cboCustomerStatusID = 1 Then 'Normal Status to If Me.cboCustomerStatusID.Column(0) = 1 Then 'Normal Status

Are you able to upload a copy of the database with no Confidential data?

Hi John Can you upload the database?

Hi John Have you tried changing the form layout to Candidate - Vacancies?

Would it not be easier to have your Main Form based on Candidate_tbl with the subform based on vacancyCandidate_tble?

Sorry John but you would never allow duplicate records in Candidates_Tbl

John I would suggest that you add the Application date & Determination date to the Subform.

Can you upload a copy of the database?