can I set up a text box so that users can add, but not change? 1

[keun]

I have a form that is used to look up existing projects, and to add new projects. I only want users to be able to add projects, not edit or delete existing.

Is this possible?

 

[AndyInNC]

The form has Allow Edits, Allow Deletions, and Allow Additions settings on the property page (Data tab) that you can look into, but be sure that the user understands what is going on. It could be confusing if the user sees the control and tries to change the data, but Access doesn't allow it.

(I'm assuming that the form will be displaying existing data as well as creating new data, but I might be wrong on this.)

One way to handle it is when you open the form to an existing record (if that will be allowed) disable all the controls so they can still view the data. Another approach, if the form will only be for new data (not looking at old), is to set a filter to prevent the display of any existing records in the form when it's opened.

 

[TheAceMan1]

How are ya keun . . .

Try the following in the forms [blue]On Current[/blue] event:

[blue]   Dim flg As Boolean
   
   If Me.NewRecord Then flg = True
   Me.AllowEdits = flg
   Me.AllowDeletions = flg[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jerryreeve]

Have you looked at the methods that the built in switchboard uses? such as 1 tab/button for add new XXX and another for view XXX with the view locked so your users cannot edit.

----------------------------
Hill?? What hill??
I didn't see any $%@#(*$ Hill!!
----------------------------
JerryReeve
Communication Systems Int'l
com-sys.com

 

[keun]

Thanks for the feedback all. I am going to try AceMan's suggestion today.

The reason that I need to view and add on the form is that this form contains a look-up function to confirm that an existing customer is not already entered. Once the user confirms such, the user can enter the new customer. What I don't want is for someone to open the form and start hammering away on an existing entry, nuking the data that was in there.

 

[keun]

I am here to report back that AceMan's solution worked like a champ!

 

[TheAceMan1]

jerryreeve . . .

I posted what I knew would work off the top of my head, however, just like in math where you reduce to lowest terms ... the code can be reduced to just two lines:

[blue]  Me.AllowEdits = Me.NewRecord
  Me.AllowDeletions = Me.NewRecord[/blue]

Cheers!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]