Record add in a grid

[telande35]

Hey,

I made a form and therin a subform. Based om a query. The subform is in datagrid-view.
No I want to add , update records in that view.
The propertys (allow edits, allow deletion, allow add) of the main form and subform are set to YES.

But I can't change or add a record.

What could be wrong?

Also I the gridview of the subform I want to edit a memo-field. How can I do this? It shows me only 1 line and not a box of a few lines, or maybe when you edit it, it opens the box. Is there some solution to do it in the same grid?

Thanks
nic

 

[mrsbean]

Check your primary key field(s) in the subform. You must have this field available in the subform. If you want, you can hide it, but it has to be present in the query, or data cannot be added.

MrsBean

 

[telande35]

The recordsource is in both (main and subform) the same query which include the primary key.
The primary key is not an autonumber it is a textfield that the user has too fill up.

nic

 

[PHV]

The query must be updatable.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

How are ya telande35 . . . . .

[blue]PHV[/blue] is on target. To tell if your queries are updateable, [blue]open the main form in form view[/blue] and have a [blue]look at the navigation buttons[/blue]. If the [purple]New Record button has that disabled look[/purple], then the query is not updateable (same if you design a query in design view & run it).

[blue]If the above is true, post the queries so we can have a look . . .[/blue]

See Ya! . . . . . .