Can't edit access database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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


John W. Vinson[MVP]
 
Yes, I am editing them in form view. What do you mean Recordsource property?
Click to expand...

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]
 
Back
Top