Recent content by spacemunkee

Private Sub Command40_Click() On Error GoTo Err_Command40_Click DoCmd.SetWarnings False 'Turn Warnings Off DoCmd.RunCommand acCmdSaveRecord DoCmd.SetWarnings True 'Turn Warnings On Exit_Command40_Click: Exit Sub Err_Command40_Click: MsgBox Err.Description Resume...

I think i have solved it :) The query has now been deleted and i am using the following: In my combo box - SELECT [tblSubcontractors].[Performance] FROM [tblSubcontractors] GROUP BY [Performance] In the after update code- Private Sub Combo61_AfterUpdate() ' Find the record that matches...

yes, im currently using the query to take the combo box value and to use it to find exact matches in tblSubcontractors. The query runs fine and opens up the correct records as a data sheet, but i want these to be visible in a sub form (single form view) on the same form as the combo box. Then i...

Ive spent a good 8 hours on this today to no avail :( i have even tried to reproduce the same effect using various other methods such as without using any querys just form properties, but these would only link to one result (eventhough i know there are 2 or 3 with the same performance level)...

it is currently running as a select query with all the code as i pasted in first post .. my knowledge is very basic as i have only been using access for just over a week :(

Hi all first post :) I have a table which contains technical information about subcontractors, including their performance (good,bad etc) which is chosen using a combo box when adding new records. I have decided to create a search form that contains a combo box with the same performance values...