ms access 2003- add allow text box but not edit.

Hi,

I'm using the same form for adding new records and for updating current records.

I'd like to make it so that some field value on the form will not be open for editing but would be open when adding new records.

in other words when the user creates a new record, he will be able to enter this field value, but when editing existing record this field text box will be locked for editing.

Thanks,

Anyone?

- I guess what I'd like to do is maybe in the on_current event to check if the form is currently in adding new records mode, and if so to make these control enable=true , locked=false. and otherwise to make them enable=false, locked=true.

- The only question then is: how do I know if the form is currently in adding new records mode?

Thanks,

Hi Bambo

when you launch the form, what opens first? The 'adding new records' window or the 'updating current records' window. Yes, I understand that you are using the same form for both but when you lauch the form, you need to decide what operation you need to do i.e add new records or edit current records. Based on that, two things can happen.

1) when the user clicks the "Add New" Button or the "Edit Current" Button, you need to disable the relevant control OR
2) While loading a form you decide which control to disable...

Hope it makes sense...