How to pull a value from a table in Access and show it in a textbox based on a unique ID displayed in another textbox?
I have a textbox in Form2 named txtEID with an Employee ID value that is passed from another form.
I also have a sample textbox named txtFullName that should autopopulate the name of a person from table tblEmployees with table field EmployeeName where Form2.txtEID.value is equal to EID of tblEmployees.
I don't know how to autopopulate the textbox.
I tried a ComboBox with this line in its Rowsource property:
SELECT [tblEmployees].[ID], [tblEmployees].[EmployeeName] FROM tblEmployees WHERE [tblEmployees].[EID] = [txtEID];
It is showing the desired value (person's name based on EID of txtEID) in the ComboBox but only as a dropdown list.
How can I set the value of the textbox txtFullName to a person's name from the table based on the EID showing in txtEID?
I also don't know how to set it up in the txtFullName Control Source property.
Use DLOOKUP in the Control Source to pull the information.
DLookUp("[Full_Name]","[Table1]","[EID]=" & [txtEID])
I've wrapped it in an IIF statement as it returns an error if the txtEID control on the form is null.
=IIf(IsNull([txtEID]),"",DLookUp("[Full_Name]","[Table1]","[EID]=" & [txtEID]))
- How to select the highest Number in a column in accordance to Highest number in another column
- VBA - Text to columns in specific row
- VBA Date in Office 365
- Move the cursor to a cell in the Excel sheet according to the cell value in another Excel sheet
- Create an Outlook meeting invitation using text and formatting from a Word document using Excel VBA
- How to align texts to the left and right side of TextBox
- How to sort data of Sheet1 using a Combobox with values from Sheet2?
- Select multiple rows, copy and paste
- How to select and copy specific contents to other tables
- Getting "Run TIme Error 13: Type Mismatch" while parsing a JSON using JSONConverter
- If Values from Column A in Sheet 2 doesn't exist in Column A Sheet 1 then add text to that row in sheet 1
- VBA check if object is set
- VBA: How to use one ListBox to tick checkboxes in other 3 Listboxes
- Excel Dynamic Grouping/Hierarchy Tool With Merged Rows
- Where is your personal macro workbook located?
- Keeping Macros identical across several workbooks
- Use Environ("LOCALAPPDATA") with a Public Const. (or an alternative solution)
- Macro to insert two rows and three columns of cells below a selected range
- Listagg, Excel Formula, concatenate, list, group, comma seperated
- How can I determine which cell(s) in a watched range are changed?
- Excel VBA ODBC reading field changes it to Null
- Assigning User Selected Color to Variable
- Determine if cell contains data validation
- VBA TalentLMS API Post Request with multipart/form-data throwing error when passing Request Body with boundaries in as a string parameter
- Two cell values combined always equal 1
- What is causing array type mismatch?
- Permission Denied, Error 70 When You Use OpenTextFile Statement in Excel VBA
- VBA to Set Uniform Colors for Clustered Column Chart Bars in Excel
- Constant Declaration Conventions
- How to pull a value from a table in Access and show it in a textbox based on a unique ID displayed in another textbox?