Pass record id from continuous form 2

[lachesis]

I have a continuous form (actually a sub form, but you get the idea). On each record row I want to put an Edit button that kicks the user to another form.

What I want to do is pass the record ID of the row whose Edit button is clicked. Is there an easy way to tie the each Edit button to its corresponding record, so the record ID lookup process is transparent??

I'm kinda stuck for ideas with this one. I could end up with hundreds, if not thousands of records, so writing code for each Edit button is not feasible.

thanks
L.

 

[scriverb]

You can pass the Record ID of a record by storing it in a Global variable in the OnCurrent event procedure of the subform.

Data Base module:

Global vRecID as Long

On Current event Procedure:
vRecID = Me![RecordID]

Now as you click on your Edit button and open the editing form the Global variable record value is available for you to open the form to that particular record.

Post back if you have any questions.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[gusbrunston]

[tt]
Hi:

I'm following this thread because I want to accomplish the same thing. I've been looking at the "OpenArgs" property, and found this on MS' database:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acproOpenArgs.asp

One more bit of info...

But I like Bob's suggestion. Sounds easier than procedures I've thought of.

Good luck,[/tt]

[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]

 

[lachesis]

Thanks Bob. Works like a charm!

L.

 

[scriverb]

Glad to be of help. Thanks for the star!!

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???