how to create a form that will let me alter a records once

[ShaunG]

I have a receive goods entry form that is recorded to a query.... when goods are received open form search the order number, which will come up with the ordered details to be double checked and then enter that it has been received...



I have locked all the fields bar the received goods so they cant be tampered with, but when turn edits off because the query has the ordered info in place I cant input the received info.

with edits on some can accidentally change info.

do I need to create separate querys - 1 for the received goods alone to achieve what I'm after?

can a validation rule stop edits to records once the received fields have been populated?

[ShaunG]

not sure if helps but this is form

[davegri]

You are going to have to determine if the record is locked for each record as it is displayed.
Add a field to the table, bLocked. Add it to your query and the form.
Then on your form, when the 'received by' or whatever is updated, set the bLocked to TRUE.

Then in the Form_Current event,
Check bLocked, and if true, disable all the appropriate controls.

[ShaunG]

You are going to have to determine if the record is locked for each record as it is displayed.
Add a field to the table, bLocked. Add it to your query and the form.
Then on your form, when the 'received by' or whatever is updated, set the bLocked to TRUE.

Then in the Form_Current event,
Check bLocked, and if true, disable all the appropriate controls.

I had to change the above a little as I found this wasn't adequate.. one order may have 2 or 3 items that might come in at different times.

ive added a subform of the ordered items to the above form....... and created a hyperlink from that item which opens a single form with just that items details.

I was working on a separate lock / unlock button which I actually just posted in programming thread.

I believe what you have should work being its all on one form, will it also disable the check box?

[davegri]

I believe what you have should work being its all on one form, will it also disable the check box?

Don't show a check box. If you're referring to bLocked, the visible property can be NO.

[ShaunG]

How does this look?

Private Sub Form_Current()
If Me.OrderComplete = True Then
[Forms]![sfRecievedGoods]![DateReceived].Enabled = False
[Forms]![sfRecievedGoods]![QtyReceived].Enabled = False
[Forms]![sfRecievedGoods]![Employee].Enabled = False
[Forms]![sfRecievedGoods]![OrdersComplete].Enabled = False
End If
End Sub

[ShaunG]

Don't show a check box. If you're referring to bLocked, the visible property can be NO.

yeah I was referring to it.... sorry im a little confused if the check box is invisible how is it checked once the data is updated?

[ShaunG]

Don't show a check box. If you're referring to bLocked, the visible property can be NO.

just mucked around with and its working mate cheers for the help....