Delete Underlying Record from Table Using Command Button 1

[Ajwebb]

Not Sure if this is possible, but i have a form with a list box on it. The record source for the list box is from a table.

Is it possible to select one of the rows in my list box and then delete using a command button.

When i say delete the record in the list box, i mean to delete the underlying record in the table.

Thanks for any help

Anthony

 

[Ajwebb]

Thanks Again Andy.

Works great, you're a star.

Have a good Weekend.

Anthony

 

[Ajwebb]

One more question,

If i want to add more where statements to the above, how would i go about doing it?

Thanks

Anthony

 

[MakeItSo]

Just add an AND to it:
where [learning activity dataset].[learn_id]='" & Me!List3.Column(0) &"' AND [lastname]='Miller' AND ..."

;-)
ANdy

 

[Ajwebb]

Thanks Again Andy.

Much Appreciated

Ant