Morning All,
I have attached the database that I am currently working on. I am trying to use a form that displays all 'outstanding' surveys and use a command button that opens another form diplaying the details of the specific record.
The code I am using to do this is as follows:
[vba]DoCmd.OpenForm "Surveys", , , "CustomerID = " & Me.CustomerID_List & ""
DoCmd.Close acForm, "menu", acSaveNo[/vba]
I have a feeling that this isn't working due to the subform's on the 'Survey' form that open's displaying the specific record.
Can anyone advise if the above code I'm using needs to be amended or if this isn't the right way to open the record.
The database table's will need to be re-linked to CSS_BE.mdb before opening.
Regards,
Matt