Can't keep focus on second row of subform

[KDeveloper]

Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in datasheet view
(named KTable), while the second subform is in continiuos form view (named
KNotes). In the parent form, I have a text box named ID. The text box has the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I select a
new row of KTable. So far everything is OK. The problem is when I want to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false, everything work
fine. But when KTable is ordered, I get this problem: I can only keep focus
on the first row of the KNotes subform. If I click on an other row, or the
insert-new-post rows, focus goes immidietly back to the first row, and to the
first column of that row. This makes it almost impossible (unless I'm VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?

 

[Mark A. Sam]

I don't know why your subform is behaving that way. I sounds like it is
requerying. I've never used the Orderby Property but suggest that you use
and SQL statement for the subform's recordsource and set the field order
that way.

God Bless,

Mark A. Sam

 

[KDeveloper]

I can't use ORDER BY in the SQL statement, because I want the user to be able
to choose which field(s) to order by.

I think you are right that my subform is requering. When I click on another
row but the first, there is a short "Calculating..." message in the satus
bar, and then it goes back to the first post. But no visual basic og marco
code is running, so I don't know why it does this.

I don't know why your subform is behaving that way. I sounds like it is
requerying. I've never used the Orderby Property but suggest that you use
and SQL statement for the subform's recordsource and set the field order
that way.

God Bless,

Mark A. Sam

Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in datasheet view
(named KTable), while the second subform is in continiuos form view (named
KNotes). In the parent form, I have a text box named ID. The text box has
the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I select a
new row of KTable. So far everything is OK. The problem is when I want to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false, everything work
fine. But when KTable is ordered, I get this problem: I can only keep
focus
on the first row of the KNotes subform. If I click on an other row, or the
insert-new-post rows, focus goes immidietly back to the first row, and to
the
first column of that row. This makes it almost impossible (unless I'm VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?

 

[Mark A. Sam]

It sounds like you have something going on in code to requery the KNotes
subform. You can reroder the rows using code, but resetting the
Recordsource for the KTable form. I don't know if that will solve it, but
worth a try.

I can't use ORDER BY in the SQL statement, because I want the user to be
able
to choose which field(s) to order by.

I think you are right that my subform is requering. When I click on
another
row but the first, there is a short "Calculating..." message in the satus
bar, and then it goes back to the first post. But no visual basic og marco
code is running, so I don't know why it does this.

I don't know why your subform is behaving that way. I sounds like it is
requerying. I've never used the Orderby Property but suggest that you
use
and SQL statement for the subform's recordsource and set the field order
that way.

God Bless,

Mark A. Sam

Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in datasheet
view
(named KTable), while the second subform is in continiuos form view
(named
KNotes). In the parent form, I have a text box named ID. The text box
has
the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I select
a
new row of KTable. So far everything is OK. The problem is when I want
to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false, everything
work
fine. But when KTable is ordered, I get this problem: I can only keep
focus
on the first row of the KNotes subform. If I click on an other row, or
the
insert-new-post rows, focus goes immidietly back to the first row, and
to
the
first column of that row. This makes it almost impossible (unless I'm
VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?

 

[Mark A. Sam]

Are you using Access 2007?

I can't use ORDER BY in the SQL statement, because I want the user to be
able
to choose which field(s) to order by.

I think you are right that my subform is requering. When I click on
another
row but the first, there is a short "Calculating..." message in the satus
bar, and then it goes back to the first post. But no visual basic og marco
code is running, so I don't know why it does this.

I don't know why your subform is behaving that way. I sounds like it is
requerying. I've never used the Orderby Property but suggest that you
use
and SQL statement for the subform's recordsource and set the field order
that way.

God Bless,

Mark A. Sam

Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in datasheet
view
(named KTable), while the second subform is in continiuos form view
(named
KNotes). In the parent form, I have a text box named ID. The text box
has
the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I select
a
new row of KTable. So far everything is OK. The problem is when I want
to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false, everything
work
fine. But when KTable is ordered, I get this problem: I can only keep
focus
on the first row of the KNotes subform. If I click on an other row, or
the
insert-new-post rows, focus goes immidietly back to the first row, and
to
the
first column of that row. This makes it almost impossible (unless I'm
VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?

 

[KDeveloper]

It's Access 2000.

Are you using Access 2007?

I can't use ORDER BY in the SQL statement, because I want the user to be
able
to choose which field(s) to order by.

I think you are right that my subform is requering. When I click on
another
row but the first, there is a short "Calculating..." message in the satus
bar, and then it goes back to the first post. But no visual basic og marco
code is running, so I don't know why it does this.

I don't know why your subform is behaving that way. I sounds like it is
requerying. I've never used the Orderby Property but suggest that you
use
and SQL statement for the subform's recordsource and set the field order
that way.

God Bless,

Mark A. Sam


Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in datasheet
view
(named KTable), while the second subform is in continiuos form view
(named
KNotes). In the parent form, I have a text box named ID. The text box
has
the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I select
a
new row of KTable. So far everything is OK. The problem is when I want
to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false, everything
work
fine. But when KTable is ordered, I get this problem: I can only keep
focus
on the first row of the KNotes subform. If I click on an other row, or
the
insert-new-post rows, focus goes immidietly back to the first row, and
to
the
first column of that row. This makes it almost impossible (unless I'm
VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?

 

[Mark A. Sam]

That was a real buggy version. When I was developing with it, I recall many
strange and bizarre issues that couldn't be address. I had to do countless
workaround. I'm not claiming that is your problem, but if you are able to
run it on Access 2002 I'd recommend it.

It's Access 2000.

Are you using Access 2007?

I can't use ORDER BY in the SQL statement, because I want the user to be
able
to choose which field(s) to order by.

I think you are right that my subform is requering. When I click on
another
row but the first, there is a short "Calculating..." message in the
satus
bar, and then it goes back to the first post. But no visual basic og
marco
code is running, so I don't know why it does this.

:

I don't know why your subform is behaving that way. I sounds like it
is
requerying. I've never used the Orderby Property but suggest that you
use
and SQL statement for the subform's recordsource and set the field
order
that way.

God Bless,

Mark A. Sam


Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in datasheet
view
(named KTable), while the second subform is in continiuos form view
(named
KNotes). In the parent form, I have a text box named ID. The text
box
has
the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I
select
a
new row of KTable. So far everything is OK. The problem is when I
want
to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false, everything
work
fine. But when KTable is ordered, I get this problem: I can only
keep
focus
on the first row of the KNotes subform. If I click on an other row,
or
the
insert-new-post rows, focus goes immidietly back to the first row,
and
to
the
first column of that row. This makes it almost impossible (unless
I'm
VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?

 

[KDeveloper]

They have no plans to upgrade, so I think I'll have to do some workaround
too. A dialog box or something.

Thank you for your interest.

That was a real buggy version. When I was developing with it, I recall many
strange and bizarre issues that couldn't be address. I had to do countless
workaround. I'm not claiming that is your problem, but if you are able to
run it on Access 2002 I'd recommend it.

It's Access 2000.

Are you using Access 2007?


I can't use ORDER BY in the SQL statement, because I want the user to be
able
to choose which field(s) to order by.

I think you are right that my subform is requering. When I click on
another
row but the first, there is a short "Calculating..." message in the
satus
bar, and then it goes back to the first post. But no visual basic og
marco
code is running, so I don't know why it does this.

:

I don't know why your subform is behaving that way. I sounds like it
is
requerying. I've never used the Orderby Property but suggest that you
use
and SQL statement for the subform's recordsource and set the field
order
that way.

God Bless,

Mark A. Sam


Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in datasheet
view
(named KTable), while the second subform is in continiuos form view
(named
KNotes). In the parent form, I have a text box named ID. The text
box
has
the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I
select
a
new row of KTable. So far everything is OK. The problem is when I
want
to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false, everything
work
fine. But when KTable is ordered, I get this problem: I can only
keep
focus
on the first row of the KNotes subform. If I click on an other row,
or
the
insert-new-post rows, focus goes immidietly back to the first row,
and
to
the
first column of that row. This makes it almost impossible (unless
I'm
VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?

 

[Mark A. Sam]

The only other thing I can suggest is to check the code in the Current Event
of the form or the Enter Event of the subform control. There just may be
something there that you didn't consider.

They have no plans to upgrade, so I think I'll have to do some workaround
too. A dialog box or something.

Thank you for your interest.

That was a real buggy version. When I was developing with it, I recall
many
strange and bizarre issues that couldn't be address. I had to do
countless
workaround. I'm not claiming that is your problem, but if you are able
to
run it on Access 2002 I'd recommend it.

It's Access 2000.

:

Are you using Access 2007?


I can't use ORDER BY in the SQL statement, because I want the user to
be
able
to choose which field(s) to order by.

I think you are right that my subform is requering. When I click on
another
row but the first, there is a short "Calculating..." message in the
satus
bar, and then it goes back to the first post. But no visual basic og
marco
code is running, so I don't know why it does this.

:

I don't know why your subform is behaving that way. I sounds like
it
is
requerying. I've never used the Orderby Property but suggest that
you
use
and SQL statement for the subform's recordsource and set the field
order
that way.

God Bless,

Mark A. Sam


message
Hi all. Hope you can help me with this question.

I have a form with two subforms on. The main subform is in
datasheet
view
(named KTable), while the second subform is in continiuos form
view
(named
KNotes). In the parent form, I have a text box named ID. The text
box
has
the
following source: =[KTable].controls("ID")

The KNotes subform is linked to this ID text box.

This construction will display the related rows of KNotes when I
select
a
new row of KTable. So far everything is OK. The problem is when I
want
to
change some of the values in KNotes.

If KTable.form.orderby is not set, or oderbyon is false,
everything
work
fine. But when KTable is ordered, I get this problem: I can only
keep
focus
on the first row of the KNotes subform. If I click on an other
row,
or
the
insert-new-post rows, focus goes immidietly back to the first
row,
and
to
the
first column of that row. This makes it almost impossible (unless
I'm
VERY
fast) to change anything but the first row of KNotes.

Can anyone help me with this?