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.
- Moving Files in MSOffice Access 2010
- How to format a general date to a distinct month in a combobox dropdown list in Access VBA?
- Date/Time Format VBA Access Query
- Use SQL to combine multiple Crosstab query results into individual Bins (ranges)
- Referring to a subform as recommended produces an error
- Building <select> in Access form
- Method 'columns' of object '_Global' failed error - VBA Access
- how can i extract the form information from a .mdb file?
- Dlookup syntax with multiple criteria including "Like"
- MSCAL.OCX not working on MS Access 2010(64-bit) on Windows 10(64-bit)
- MS Access Listbox click will not register a listbox selection
- Access VBA: How do I make the VBA editor stop auto-filling values?
- VBA Replace “Start” attribute deletes text
- Search by specific date in Access database with VB.net
- Sum Time Field in Access
- What are the Pros and Cons of VBA Code vs Macros in MS Access?
- How to reduce ms access database file size(*.accdb) after deleting data in it (MS Office 2007)
- How do I open an old Microsoft Access adp file with invalid connection strings?
- I need to split a text column in Access that stores dates in MM/YYYY and MM/DD/YYYY format to remove the day format
- Query to Find Adjacent Records in Access 2016
- Access VBA create a new table in an email when the field changes
- Microsoft office Access `LIKE` VS `RegEx`
- What is wrong with the variable?
- Error in odbcConnectAccess2007("BD-Embalses.mdb"). R could not find the function "odbcConnectAccess2007" after installing and loading RODBC
- SQL Learner -- MS Access 2013 ON UPDATE CASCADE and ON DELETE CASCADE
- Why does Access-Vba stops even if AllowSpecialKeys is turned off?
- How to disable access security notice "A Potential security concern has been identified"
- How to speed up the tranfer of information between Excel and Access?
- Access VBA MSHTML document with scripts loads slowly
- Populating subform fields from main form field