Strange goings on

[jdbegg]

Hi all,

There is hopefully a simple fix to my problem...it's baffling me

I have a Command Button on my form which opens another form. Both forms use data from the same table.

I don't want the user to be able to change two fields on the opened form. The third field on the opened form is a free text memo field. To keep the user from updating those two fields I set their property to "Locked".

When testing the form, I could put text into the memo field once, but couldn't update or edit. Every time I click into the field the scroll bar for the field disappears.

How can I get the field to be updatable, but keep the other two fields from being modified?

Thanks in advance for the help,

JDB

 

[boblarson]

Are you using a bound form with a query for the recordsource? If so, double check that it is an Updateable query. What you can do, is to unlock the two textboxes (I'm assuming the two fields you are talking about are using textboxes) and see if it works to update them. Check the status bar at the bottom of the Access screen to see if a message appears that says "This recordset is not updateable."

 

[jdbegg]

BL,

I don't know what I did, but somehow the problem was fixed. All I did was to look at the code for a Save button I had on the form (didn't delete or anything) and everything started to work..... go figure...

Thanks for taking the time to reply.

JDB