form to delete records

[cadillac]

how can i create a form that deletes record from a table, but only the ones with the number that is entered into a textbox on the form? textbox1 = 55 so all the records in the table with 55 in field x are deleted. i know it must be simple, but i need to be pointed in the right direction.

thanks

 

[pcs]

start by creating a select query (safety first!)...

in the critera section for the field you wish to match put

[Forms]![YourForm]![YourControl]

save the query. on your form put a command button to execute the query. when you are satisfied that it is returning the proper records, change the query type to a Delete query.

hth,
al

 

[cadillac]

thanks for the help........worked great.