preventing changes to record

[David B]

In an app I have orders are entered into sunsaletbl - through a form.

When the invoice section is entered all records in the sunsaletbl are
grabbed and put into invtranstbl and marked in sunsaletbl.

This all works fine.

However if for example on delivery the customer only takes 5 bottles instead
of 10 ordered, i advise users to enter a new record of -5.

However some insist on making a change in sunsaletbl and because the record
has already been sent to inv that change does not go to invoice

I think the way to fix this is to prevent changes to the record if the
gonetoinv is yes.

Appreciate advice on how to do this
TIA

David B

[David B]

"David B" <da***@marleycote.fsnet.co.ukwrote in message
news:3I********************@bt.com...

In an app I have orders are entered into sunsaletbl - through a form.

When the invoice section is entered all records in the sunsaletbl are
grabbed and put into invtranstbl and marked in sunsaletbl.

This all works fine.

However if for example on delivery the customer only takes 5 bottles
instead of 10 ordered, i advise users to enter a new record of -5.

However some insist on making a change in sunsaletbl and because the
record has already been sent to inv that change does not go to invoice

I think the way to fix this is to prevent changes to the record if the
gonetoinv is yes.

Appreciate advice on how to do this
TIA

David B

This seems to work -

If Me.Text52 = 0 Then
AllowEdits = True
Else
AllowEdits = False
End If

Any probs doing it this way ?
DB

[Bob Quintal]

"David B" <da***@marleycote.fsnet.co.ukwrote in
news:Mt******************************@bt.com:

>
"David B" <da***@marleycote.fsnet.co.ukwrote in message
news:3I********************@bt.com...

>In an app I have orders are entered into sunsaletbl - through
a form.

When the invoice section is entered all records in the
sunsaletbl are grabbed and put into invtranstbl and marked in
sunsaletbl.

This all works fine.

However if for example on delivery the customer only takes 5
bottles instead of 10 ordered, i advise users to enter a new
record of -5.

However some insist on making a change in sunsaletbl and
because the record has already been sent to inv that change
does not go to invoice

I think the way to fix this is to prevent changes to the
record if the gonetoinv is yes.

Appreciate advice on how to do this
TIA

David B

This seems to work -

If Me.Text52 = 0 Then
AllowEdits = True
Else
AllowEdits = False
End If

Any probs doing it this way ?
DB

It's good practice to prefix the allowedits property with the
full name of the form or the Me. qualifier

You can even simplify the whole thing to a single line:
Me.AllowEdits = (me.text52=0)

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com