deleting records

[ionutdinulescu]

I have a form with a listbox filled with records from a table. When I click on a record, a new form appears, where I can delete this record. After I invoke :
List.Recordset.Requery
List.Requery
the deletion is reflected, but the record is not gone, only filled with #deleted.
Is there any workaround for this ?

 

[PHV]

And this ?
List.RecordSource = List.RecordSource

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ionutdinulescu]

That didn't help, neither. I don't know what is the cause.

 

[PHV]

And this ?
Application.Echo False
List.RecordSource = ""
DoEvents
List.RecordSource = List.RecordSource
Application.Echo True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ionutdinulescu]

Am I stupid ? I forgot to specify acDialog when opening the second form.