Getting the value for the current record

S

Steve

I was wondering if there was a way (or a function) to get
Access to give me the value of the current record (the one
the user is viewing), ie if the user is looking at FormA,
record 1, the value of the function (or whatever) would be
1?? Any help would be greatly appreciated. Thanks.
 
J

John Spencer (MVP)

You should be able to use the form's currentrecord property for this.

In the current form it would be

lngRecord = Me.CurrentRecord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Calculate the median value before a specified list 0
Page numbering with Merged Document and IF statements 1
Autonumber field in Excel that behaves the same as Access 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Visio Utilizing 100% Memory - Troubleshooting 0
Copy previous record into form field 0
Corrupt PST 2x/week HELP! 0

Top