How to bind textbox value to the table if Control Source has = DLookup inside it

[Pookiemeister]

I'm still learning Access and I have a few questions.

1. I believe that "Control Source" links the matching field textbox from the form to that field in the table. Is that correct? I learned that if I need to pull data to the matching field in the forms textbox DLookup is the best option.
2. If I put the DLookup inside the Control Source, how do I bind it to the table?

So I have a query named "EmployeeQuery" that DLookups uses to populate that textbox.

=DLookUp("FullName","EmployeeQuery","Badge_ID = " & Nz([EmpBadgeID],0))

Since this code is placed inside the "Control Source" how can I bind that found textbox.value to the table? I hope my question is easy to understand. Thank you.

 

[Micron]

1) True but correctly put, the the control source property identifies which query or table field that the control is bound to.
1b) No. Bound fields are the best approach most of the time.
2) You cannot. Your example is about a calculated control (it's not a field). See 1b.
Queries should virtually never use domain lookup functions. If that statement is related to the following

=DLookUp("FullName","EmployeeQuery","Badge_ID = " & Nz([EmpBadgeID],0))

then that is not a query, it's an expression. No disrespect intended, but since you're posting on an Excel site I imagine your table designs will not be proper. You might want to review these to get off to a better start than a lot of people. Too many Excel users suffer from spreadsheetitis because they didn't study db normalization.

Normalization Parts I, II, III, IV, and V

What Is Normalization, Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

and/or

Database Normalization – Holowczak.com Tutorials

holowczak.com

Entity-Relationship Diagramming: Part I, II, III and IV

Entity-Relationship Diagramming: Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

How do I Create an Application in Microsoft Access?

How do I Create an Application in Microsoft Access?

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

Naming conventions
- General: Commonly used naming conventions
- MS Access Naming Conventions

What not to use in names
- Microsoft Access tips: Problem names and reserved words in Access

About Auto Numbers
- General: Use Autonumbers properly

The evils of lookup fields - The Access Web - The Evils of Lookup Fields in Tables
Table and PK design tips - Microsoft Access Tables, Primary Key Tips and Techniques
About calculated table fields - Microsoft Access tips: Calculated Fields
About Multi Value Fields - Multivalued Fields

Last/First/DLast/DFirst Explained
- ORDER BY - First, Last and always!