Search results

On opening the mainform Private Sub SetCtrlProps() Me.OrderDate.Enabled = Me.OrderStatusID <> 5

Bob, I appreciate your help, but it does not help:) What code and where should I put instead of AfterUpdate Requery?

Error message "Invalid use of NULL"

how?

I am sorry, lost both of you. I am not familiar with VBA jargon "You just Call the form_current" - what it means? What should I use instead of requery in order not to be thrown to the 1st record?

I've managed with this: Private Sub Form_Current() If Me.OrderStatusID = 5 Then Me.OrderDate.Enabled = False Me.CustomerID.Enabled = False Me.TransactionTypeID.Enabled = False Me.PaymentTypeID.Enabled = False Me.OrderNotes.Enabled = False Me.InvoiceNumber.Enabled = False...

Thank you again. I guess I should add some code in the Combo AfterUpdate or in subform Requery so that Enable\Disable will apply with immediate effect, without refreshing the form?

Thank you for your reply. Something is missing. Should I change the AllowEdits property of the Mainform to No first?

Dear Bob, thank you for your reply. I was looking for more systematic solution for the Mainform (not locking every control separately). I will try your solution again. Also, comboboxes on the subform, although disabled for updates, still open its value lists (not completely frozen). I've been...

Thank you for your solution. Unfortunately it locks only the subform. I need to lock both Mainform and Subform except for the combobox control itself.

I am building a simple Order form with OrderDetails subform. I need all the controls on the main form (CustomerName, OrderDate etc) and on the subform (Quantity, Listprice etc) to become locked (changes disabled) once I select Closed status in the OrderStatus combobox of the main Order form...