Continuous form only referring to the first record
I have a continuous form - one of the fields on the form is RecordID.
I have a label on that form, that when clicked should produce a message box with the RecordID in it via VBA:
MsgBox Me.RecordID
The label is reproduced on each row of the Continuous Form, but will only reference the first record. Even though I can see the RecordID field is different in each row of the form, I always get the same result, in this case 80029.
What's up with that?
Me.RecordID refers to the RecordID of the current record, as indicated by the black triangle in the record selector:
A Label control on a form cannot receive the Focus, so when you click on the label in another record the current record does not change and you keep getting the same RecordID. Note that if you put the same code into the Click handler for a textbox (or some other control that can receive the Focus) then the current record will change and you'll get the RecordID of that record.
- How to extract the schema of an Access (.mdb) database?
- Manipulating an Access database from Java without ODBC
- How to overlap microsoft access - report detail section layout to the previous one to avoid extra rows?
- What can trigger MS Access autoexec vba macro?
- Import recordset from Access to VBA ListBox
- Check if access table exists
- MS Access: There isn't enough memory to perform this operation (Reports)
- How to pass an array to a function in VBA?
- Getting "Too many parameters for command", when calling WinSCP command-line from VBA
- MS-ACCESS Difference between TempVars and TempVar
- Create a MS Access Pivot Query that returns rows even if there are null values
- Microsoft Access SQL is clipping a string when using INSERT to add a record
- Exporting a query result into a text file using vba-MS Access
- VBA referencing external module in .accdb database "tantrum"
- Is there a shorter way of appending information to an existing string?
- How can I automatically update the data in a record when I create a new record in a different table?
- ODBC driver for MS Access seems missing (Windows 64 bit)
- Access is multiplying my query count by 38.... why?
- VBA "does not equal" code not stepping through IF statement as expected
- Issues with Uploading Files to Azure Blob Using WinINet API in VBA (Error 12031)
- Splitting a full name string into First, Last and Middle Initial in VBA Access
- SQL string throws "External Name not Defined" error when running in VBA module - Name is defined
- How fast is SQLite compared to Microsoft Access MDB?
- SQL query left join with sum,group by and order by in MS Access
- ms access negative page numbers
- Number of users to a webpage
- How to get an item value from JsonObject
- Microsoft Access and paging large datasets
- Delete VBA module
- Access VBA For Loop throwing error of "No Current Record" after 1 iteration of code