Search results

Hi, Thanks for your response. It came up red in the bit you had changed, I've added a speech mark before the [tblManager].[Surname] so that it works and now it looks like this: Private Sub cboLocationID_AfterUpdate() Dim sManagerSource As String sManagerSource = "SELECT...

I'm looking at it with a fresh set of eyes today. I've changed the code to: Private Sub cboLocationID_AfterUpdate() Dim sManagerSource As String sManagerSource = "SELECT [tblManager].[ManagerID]," & _ " [tblManager].[Forename]," & _ "...

Apologies, I didn't quite finish the last sentence. Post edited.

Thank you for pointing me in the right direction. I think I am getting there, I've looked at the two links you've kindly provided above, but I am not knowledgeable enough to make them work for my db. I've found a website which was perfect (though I can't add it due to my postcount but it is on...

Hi There, I'm not sure that this is the correct section... I have a form whereby a user for my database can be created. The fields required are listed below: Payroll ID Forename Surname Location Manager The last two fields are related to two other tables; tblLocation and tblManager, which...

Hi All, I'm not sure about the best way to go about this as I'm new to access... I've got a bit of a headache so hopefully I am explaining things properly! I'll explain the relevant tables first: tblEmployees UserID (PK - Autonumber) PayID (Unique employee ID) EmpName (Employees' first...