Can't edit access database?

[Guest]

I have created a database for mail merge letters. But when I go to edit a
record the edit box is grey. What do I need to do to be able to edit my
records?

 

[Guest]

Check to see if the Enabled property of the text box = True

 

[John Vinson]

I have created a database for mail merge letters. But when I go to edit a
record the edit box is grey. What do I need to do to be able to edit my
records?

How are you trying to edit the record? In a Form? If so, what is its
Recordsource property?


John W. Vinson[MVP]

 

[Guest]

Yes, I am editing them in form view. What do you mean Recordsource property?

Jenza

 

[John Vinson]

Yes, I am editing them in form view. What do you mean Recordsource property?

A bound Form must be based on a Table or a Query - this is called the
form's Recordsource. Open the form in design view, and view its
Properties (with the View menu option, or rightclick the little square
at the upper left intersection of the rulers and select Properties).

The first property on the Data tab is the Recordsource. Normally this
will be the name of a table or query, or it might be a SQL string.

If it's a query, try clicking on the ... icon by the property (it will
appear when you've selected that line of the properties window). Can
you open the query in datasheet view (by clicking the leftmost icon in
the toolbar)?

John W. Vinson[MVP]