Delete record matching form value 1

[omooreirl]

Hi

I have a form in which the use enters a batch number. On clicking Continue, the table is referenced to see whether the value exists or not. If it does then the user has the option to delete the row in the table.

The code I am using for the delete query is as follows:
DoCmd.RunSQL Delete tblStoredBatches.TempBatchID FROM tblStoredBatches WHERE (tblStoredBatches.TempBatchID) = 1d2222

Can anyone help?

OM

 

[omooreirl]

Apologies - just to clarify:
Tempbatchid is the table field that I am checking to see whether the form value against. The form value is also called tempbatchID:
DoCmd.RunSQL Delete tblStoredBatches.TempBatchID FROM tblStoredBatches WHERE (tblStoredBatches.TempBatchID) = Me.TempBatchID.Value

OM

 

[JoeMicro]

DoCmd.RunSQL Delete tblStoredBatches.TempBatchID FROM tblStoredBatches WHERE (tblStoredBatches.TempBatchID) = Me.TempBatchID.Value

is this how its formated in the vba editor?

do you get any masseges, is it running at all?

where do you have the problem?

if its only the formating then try

docmd.excute("DELETE tblStoredBatches.TempBatchID FROM tblStoredBatches WHERE tblStoredBarches.TempBatchID = '" & Me.TempBatchID & "'")

didnt try it so i hope it works

Joe

 

[PHV]

I'd try this:

DoCmd.RunSQL "DELETE * FROM tblStoredBatches WHERE TempBatchID='" & Me!TempBatchID & "'"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[omooreirl]

Thanks guys.

I'll go with PHV's solution as it was what I was trying to do in the first place.

Thanks again.

OM