Problem with list box selecting individual records
Hi, I'm currently building a database with a 'master' form that I want everyone to use instead of meddling around in the tables and such. I've got a couple of sub-forms opening up from here, including new record and edit record.
The problem lies with edit record, as I have made a list box to display the results from a search box. The results show up fine, and all records from each client are visible. However, when I go to select a specific record, it defaults to only one record per client. As most clients have multiple instances of software/hardware, it doesn't allow me to open any of the alternative records, only one record per client.
I'm using a button to open the edit data sub form, and the code I have for the on click event is:
DoCmd.OpenForm "EditData", , , "[Client_Database.Client]=" & " ' " & Me.EditRecordResults.Column(0) & " ' "
The EditRecordResults is the list box, and the after update code I have for the list box is:
EditRecordButton.Enabled = True
EditRecordButton is the same button I have the on click event for.
Any ideas what could be causing this? I'm not sure if the event code causing the issue, or if access's default list box settings are limiting my options, although I don't know how to change these either.
Any help would be greatly appreciated!