Access 2003 - Delete Record?

[ArleneM]

I want to set up a form that will ask me for information, then delete or show the matching record.

For example, if I input an employee number, it will delete all information in all tables pertaining to that employee or show me all information in all tables for that employee. So I'd have a form (?) that has a box where I enter the employee number, then two buttons - Delete or Show. Obviously, Delete would delete the record, Show would show me all the info.

Any help you can provide would be most appreciated.

Thanx,
Arlene

 

[BlueHorizon]

Hi,
There are other locations for Access threads. This questions may be more useful if posted there.


Best,
Blue Horizon

 

[fneily]

You can post in either:
Microsoft: Access Forms
Microsoft: Access Modules (VBA Coding)

You can use SQL statements to show or delete the records from the tables.

Also, as a design precaution, wouldn't you want the user to see first, then delete?

 

[kjv1611]

Here are direct links for the forums mentioned by fneily:

forum702

and

forum705

--

"If to err is human, then I must be some kind of human!" -Me