 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007System record,reccount,record number of the records in a table
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 >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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.