Deleted -SQL HELP

Deleted -SQL HELP

• Pi314159

  How about putting

  Go Top

  after the delete, but before the refresh.

  This will move the record pointer to the top of the table.

  Or You could put

  go recno() + 1

  to move to the next record.

  Greg

  
  

• NotTaken

  Is that exactly what the error message is Where is the variable 'temp' being populated

  Greg Gum

  
  

• AlexBB

  message box error: "Variable 'DELETE' is not found"
  
  temp is being declared right above it, im not sure how Grids really work yet but its getting its data directly from a table, I am displaying a command button with the ID field and this is the click method:
  
  temp = emailaddressbook.idemail
  select emailaddressbook
  DELETE FROM emailaddressbook where idemail = temp
  thisform.grd_Email.Refresh
  
  this might look silly but i was worried what kind of results i would get if i had put:
  DELETE FROM emailaddressbook where idemail = emailaddressbook.idemail
  

• Blazing Hornet

  Try putting

  thisform.resfresh()

  after the delete command and see what happens.

  Greg Gum

  
  

• Dimmi3

  that did it! thanks for all your time and help
  
  

• tiger007

  I commented it out and i still get the error, so i guess it could be anywere = /
  
  I've been placing message boxes around the program to locate the event it Errors on.  the init event is clear but when i press the command button i get the error before i get a message box from the buttons click event.  are their any events before the command button's click event
  
  

• Di Wu

  I found the problem
  I had the columns control source set the command button instead of the email - id's field, the i had the wrong name for the button (DELETE and not Cmd_Delete). so its fixed! However when I delete a field the grids lines disapear, i can fix that by focusing on them with my cursor, does anyone else know how to fix this
  
  

• mamatham

  no, whatever record is selected has the Horizontal grid lines invisible
  
  

• quame

  Hmm, I am not sure where it is coming from, but I would start over with a fresh form and copy and paste from the old to the new and you will probably lose the error.

  Greg

  
  

• Chips_in

  I cleaned it out to just say this:
  
  select emailaddressbook
  DELETE FROM emailaddressbook where idemail = emailaddressbook.idemail
  
  and i still get that error
  
  

• Hussam44

  Try commenting out the delete command and see if you still get the error. It might be coming from somewhere else as "Delete" is not a variable.

  if your already on the record that you want to delete, you can use just the command

  DELETE

  and it will delete the current record.

  There is also a

  DELETE FOR command that you can use.

  Greg Gum

  
  
• Deleted -SQL HELP