Datasheet strange beheaviour - Rookie

  • Thread starter Thread starter Atlas
  • Start date Start date
A

Atlas

I have a Access 2003 form with 3 combo boxes showing contents from 3
"cascading" tables from a sql server 2000:

A
|___ B
|____C

Content of the combo box B is populated depending on content of combo box
A;
Content of the combo box C is populated depending on content of combo box
B;

with vba coding like:

Dim strSQL As String

strSQL = "SELECT *, [ID B] AS Expr1, Descr AS Expr2 FROM WHERE [ID
A]= Me.A.Column(0)

Whenever an update occurs in combo box A, content of combo boxes B & C is
blanked.

This works perfectly on both the "cascaded" combo boxes B & C.

Unfortunatelly, when working in datasheet view or continuos form view, the
updates of the blanked or updated combo boxes (B & C) occurs out of the
current record. Say I'm working on record 3 out of 5, changes occurs also on
record 1 & 2, even if the focus is set on record 3.
BTW only the displayed values are changing on the form, not the db content.

How to prevent this?

Thanks
 
Details I've missed: the updates are done programmatically with the
..rowsource property. That may be the problem way all the rows are
changing.....

What should I do?
 
I've just read about the combo box in a datasheet or continuos form acting
as multiple objects but really being one object, that's the problem.
So there's no way to update combo boxes .rowsource property without
scarmbling data in all the rows.....???

I've tried the trick to stick a textbox in front of the combo box with the
preloaded value but also this field changes in all the rows......
 
Back
Top