Displaying records as a list in the form and then deleting records from that list

[Fran]

Hi folks

I know everyone says this but I'm a bit of a newb with Access and the small amount of VBA I understand is self taught.

I have a data entry form that just has one field to enter a loginID. I want it to list on the same form all loginIDs that have been entered so that it's easy to see at a glance which have already been added. I've managed to get it do do this using a list box, is this the best/only way? It needs to be able to update as soon as a new record is saved.

So then, my next problem is how can I delete from that list, so that it comes off the list box and also from the table it's coming from (tblusers)?

I want a delete button that when pressed, deletes which ever loginID is selected in the list box. Any ideas please?



Many thanks
Fran

[pbaldy]

Try

CurrentDb.Execute "DELETE * FROM tblUsers WHERE loginID= " & Me.ListboxName
Me.ListboxName.Requery

That makes a couple of assumptions, but see if it works.

[Fran]

Thanks for the effort, but I got an error message "Runtime error 3464, Data type mismatch in criteria expression"

Any thoughts?

[pbaldy]

If loginID is text, it would need to be:

CurrentDb.Execute "DELETE * FROM tblUsers WHERE loginID= '" & Me.ListboxName & "'"