Sample Header Ad - 728x90

MS-Access Beginner Replace Textbox Caption With Combo Box Selection on Button Press

1 vote
1 answer
294 views
I'm a complete beginner, just trying out/looking into Databases as more of a hobby, and think Microsoft Access would be an easy way to start with the whole front-end forms and back-end combination. I just have a form with a combo box [UserNameEntry] that you can select a value from a table 'Users' in a 'Alias' field and then just press a button [Command27], and another text box will have its text replaced by that string. This is more of a test/precursor before me wanting to set it to get the record matching the 'Alias' value selected in the combo box, then checking if another field in that same record matches a particular value. I don't mind if any help is in the expression, macro or VBA builder, all is good to learn. I tried the following expression in the On Click event of the button [Command27] (and many other alternatives) but haven't had much luck:
=[Command27].[Caption]="[Users]![Alias]=" & "[UserNameEntry]"
Any help would be appreciated!
Asked by SamuraiMelon (123 rep)
Feb 13, 2021, 03:11 AM
Last activity: Aug 20, 2021, 10:28 PM