2 controls on my form mapped to the same data field

[Caro]

I have a form containing 2 frames - one is visible when the other isn't and vice versa. One of the fields in my recordset is mapped on both frames. The second frame does not map it correctly. Does anyone have a solution for this??

[bar]

The second control will only update once you've updated the record and refreshed your data ie. MovePrevious, MoveNext. Then the second control should read the same as the first.

I think this is what you mean, if not please rephrase the question.

[Rocks]

Sorry cant help you, but was wondering if you could help me.

I would like th eentries on my form to be placed directly into the DB.

What object/methods would i use for this.

Any Advice would be great.

Rgds,

[bar]

Rocks,

You would use a data control for every table you want to open, then a text box bound to each field in the table.

Use the datacontrols .Recordset.Addnew for adding records.
.Recordset.Update to save the changes, and
.Recordset.edit to lock an existing record before making any changes.

[Rocks]

Will try that now, Thanks