Returning a Value from table and then deleting a value

[Adzi]

Hi there,
Im working hard on this database for work, but i've run aground on this problem. Im not even sure if its possible...

A permit number is typed into a search box. The comand button takes the search term (the permit number) and locates the record. A vbYesNo msgbox confirms the checkout action. The check-out date is entered (the "Now" function) and the permit number within the record is deleted. All this should happen with out the user's input (apart from the search term and a confirmation vbYesNo msgbox).

Im assuming a DLookUp is needed, i just don't know how to go about it.
Any help greatly appreciated

 

[dcobau]

search help for 'delete queries', create a query then use:

docmd.runcmd.openquery "queryname"

Dave