Read only Form when opened

[Gary.]

Hi

In need to be able to open a form read only until I select a record from a
combo box

I want to keep from entering the information in the first record that comes
up when I open the form

Thanks

 

[Guest]

What if it is the first record the user wants to edit?
You can set the AllowAdditions, AllowEdits, AllowDeletions properties to
False. Then make them true when the user clicks the button.

 

[Gary.]

That sounds like it would work

I Estimate for a commercial wood working firm

I use Access to track my jobs and generate Bids

For example I might bid a hotel and need to exclude 300 wood doors and
frames.

So that would go into me exclusion field

I need to make sure that the exclusion is attached to the right job

This all works on a form with a sub form, the main form is information
about the job being bid, Name address and so on the sub form is where the
information is entered about the bid.

If I were to put the exclusion in with the wrong job thin I would be in
major trouble

If it is on the plans and you don’t exclude it then you have to provide it

I wouldn’t want to have to provide 300 doors and frames that I didn’t have
money in the bed for.

All that to say I need to make sure everything about the bid is with the
right job.

Could I set the buttons where every time I change to a new record on the
main form that I would have to reactivate the form before I enter data

Any other ideas would be helpful

Thanks for you help

 

[Guest]

Yes. You can use the Form Current event. Set the properties I listed
previously to False. Then the command button can turn them back on.

With Me
.AllowAdditions = False
.AllowDeletions = False
.AllowEdits = False
End With

For the button change False to true

 

[Gary.]

Yes. You can use the Form Current event. Set the properties I listed
previously to False. Then the command button can turn them back on.

With Me
.AllowAdditions = False
.AllowDeletions = False
.AllowEdits = False
End With

For the button change False to true

Will this work on a form with a sub form?
Or will it only affect the main form and not the sub form?

 

[Guest]

It works only on the main form. If you need to do the subform also, add the
code it.

With Me
.AllowAdditions = False
.AllowDeletions = False
.AllowEdits = False
With !MySubformControlName.Form
.AllowAdditions = False
.AllowDeletions = False
.AllowEdits = False
End With
End With