System record,reccount,record number of the records in a table

[Guest]

I would like to use the sytem record or rec count or recno, something like
that in the forms.
1. Is there such a thing in Access?
2. Is there a GOTO (to send to a specific record in the table and refresh
the form)?
Well, I do have a form and a sub form.
in my sub form I have multiple records. If I want the main form to be
updated with any of the record in the sub form, I have tried the refresh
method on the field and on the sub form and on the main form with no result.
The main form does not get refreshed, so the next step was to tell it goto to
a specific record and then refresh. I cannot find anything in the help list.
Can you help? thanks

 

[John W. Vinson]

I would like to use the sytem record or rec count or recno, something like
that in the forms.
1. Is there such a thing in Access?

No.

Tables are unordered "buckets" of data. You can create a recordset based on a
table, and use the MOVE method to jump to a specific record - but you can't
count on record 1234 today being the same data as 1234 tomorrow; compacting
the database, reindexing it, all sorts of things can throw it off.

2. Is there a GOTO (to send to a specific record in the table and refresh
the form)?
Well, I do have a form and a sub form.

What are the Recordsources of the mainform and subform?

in my sub form I have multiple records. If I want the main form to be
updated with any of the record in the sub form, I have tried the refresh
method on the field and on the sub form and on the main form with no result.
The main form does not get refreshed, so the next step was to tell it goto to
a specific record and then refresh. I cannot find anything in the help list.
Can you help? thanks

Typically a Subform is used for a one-to-many relationship: the "one" side of
a one to many relationship on the mainform, the "many" on the subform. It
sounds like you're using it in a different manner! Normally a subform would
NOT "update a mainform"; what is it that you want updated?

John W. Vinson [MVP]