Non-Editable Fields and Auto Completing Fields

[revmk]

Hello all,

First post found some great tips on here. Anyway here is my story and question.

I am new to Access development. I know what I want to do, I just can not find a way of doing it .

1) I would like my form to only be editable when an edit button is clicked. I am not sure if I can do this on a form level or if I have to change each individual part. Any ideas?

2) I capture some clients details, title, first name and last name. I then need to merge the above 3 fields into one to create a 'policies in the name of' field. Is this posisble? I have tried using the initial value expression but am having no luck. Any ideas?

Thanks all

 

[workmad3]

Well, a form has an 'AllowEdits' property, I would guess you change that in the code

On the other front, is this combined in an SQL query or into another text box or...?

 

[revmk]

Hello again,

I've had a look and found that 'allow edits' bit. I can now create a button with a macro to enable edits on the push. However I am having problems turning it off again.

What I would like is a button that when pressed, disables itself, allow edits of the fields. I would then like a button to reverse this. As i previously mentioned I can allow the edits but I have not been able to disable the button or reverse the process. Any ideas?

In respect of the other issue.

It is purley a standard form using the built in database. I'm trying to get it to autofill another text box. Does that make sense?

Thanks for your help so far