void, cancel, strikeout... a Record on a form

[shy216]

is there a way to create a cmd button which can show a big X or a void so that user know it's been voided or canceled?

 

[TheAceMan1]

How are ya shy216 . . .

If a record is to be voided/cancelled, [blue]whats wrong with deleting it?[/blue]

. . . no prompts necessary!

See Ya! . . . . . .

 

[shy216]

oh, because it's going to be used from diff users, they want to keep the record even if the reservation/record is canceled.

 

[TheAceMan1]

shy216 . . .

Then [blue]you need a seperate field in the proper table[/blue] for this.

This will allow you to [blue]query & include/exclude[/blue] those specifically!

See Ya! . . . . . .

 

[shy216]

sorry... im new to access.. no clue what you're talking about...

 

[TheAceMan1]

shy216 . . .

In that case . . . have a look at the following:

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

See Ya! . . . . . .

 

[missinglinq]

The Aceman1 is right, you really do need to read up on the topics mentioned, but a simple answer would be to add a check box to your form/table, labled "Voided." You could then have a query feed a form to show voided records, non-voided records or both.

The Missinglinq

There's ALWAYS more than one way to skin a cat!