View/Edit

[databasepro]

I am trying to design a form that would do the followng:

It would open in view mode, i.e. no editing.

You could click a button to enter edit mode on the record you are currently
viewing.

Once you finished editing and saving that record, it would go back to view
only mode.

you could click a button to add a record.

Can someone point me in the right direction for this?

Thanks in advance,
/K

 

[JerryDennison]

You can set the form's properties using code. For example, to set the form's AllowEdits property you would use the following syntax:

Me.AllowEdits = True

 

[databasepro]

One more thing I forgot to mention:

I have lookup combo boxes on the form. When I set allow edits to false, it won't allow me to use the combo box to select a record.

/K

 

[JerryDennison]

This is true, you'll need to lock all controls on the form except for the combobox's you use for going to specific records and re-enable the form's AllowEdits property.