Record counter doesn't work

[XP]

I have an unbound form with a sql string in the Record Source like:

Select Name_ID from tblName;

Normally, when I do this, the record selector updates and shows the number
of records in the table; but in this case it doesn't; I think it must be a
switch I need to flip or something, but I can't seem to crack it.

Any suggestions?

 

[Linq Adams via AccessMonster.com]

Huh? If you have a Record Source your form is not unbound!

 

[XP]

Okay; whatever; the form has a Record Source, but none of the controls are
bound and the record counter never updates; even though I added a requery in
the on open event.

Any constructive ideas?

 

[pietlinden]

Okay; whatever; the form has a Record Source, but none of the controls are
bound and the record counter never updates; even though I added a requery in
the on open event.

Any constructive ideas?

:






- Show quoted text -

are the individual controls on your form bound to fields in your
recordsource? (I'd be careful with snide comments... unless you don't
want any help. biting the hand that feeds you is not a good idea.)

 

[XP]

I didn't bite first...the reply simply argued semantics and didn't offer any
help with the real issue at hand...

Thanks for reply; no, they are all unbound...is that an issue?