Record in a listbox

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hi Everyone,

I have a list of records in my listbox, but I am having
trouble bringing up a record for editing purposes. What I
am trying to accomplish is if a record is recorded
incorrectly, I want to have the user select that record
and edit it in a form that I created. Everything I have
tried is not working. Any ideas? The code below is what I
am using.

DoCmd.OpenForm "frmAudit", , , Me.AuditList.ListIndex - 1
 
DoCmd.OpenForm "frmAudit", , , Me.AuditList.Column(0)

Assuming the first column is the one to use ... columns are 0 based,
therefore Column(0) is the first, Column(1) is second etc etc ...
 
Back
Top