Display something from table

[smarty84handsome]

Can someone tell me how do i write down the code in order for something to be displayed on my report. I have employee_Table in which i have employee_name and employee_number and in my report i want to create a report in such a way that everytime i type someone employee_name i want their employee_number to be displayed automatically.

(PLS NOTE I WANT TO DO THIS WITHOUT COMBO BOX) i want someone to show me what will be code ?

[June7]

Don't understand what you want. If the report is bound to the table and textboxes bound to fields, the data should be showing on report. Explain more what you are trying to do.

[smarty84handsome]

Well i had created text box emp_name & emp_Id now i have parameter in both the fields with employee name = [employee_name] and with employee id = [employee_number] now the problem is everytime i generate a report there will be a parameter asking me which employee name i want to generate report for ? and then it ask me to input employee Id what i am trying to do is once i put employee name in parameter employee number should populate automatically.

[June7]

You have input parameters set in report's RecordSource? Access is not finding name so it prompts for input.

Provide project for analysis and I will look at.

[smarty84handsome]

You have input parameters set in report's RecordSource? Access is not find name so it prompts for input.

Provide project for analysis and I will look at.

I can't attach the file coz its too big how do I provide u with details u r right I have parameters set in record source and tht is why it is asking to input details before even I generate report. Project has Table: employee_file with list of employee_name & their corresponding EMPLOYEE_number now while generate a report for particular employee I want to see their employee number automatically on the report as mentioned before I have setup record source in such a way that everytime I generate report for particular employee their employee number should show automatically and for this I have created text box with record source [employee_number] what I wanna do is instead of setting parameter employee Id should show employee_number automatically how do I map record source to the table without using parameter method?

[smarty84handsome]

You have input parameters set in report's RecordSource? Access is not find name so it prompts for input.

Provide project for analysis and I will look at.

Or is it coz my primary key is SR_No ?

[June7]

How big? Did you run Compact & Repair? Zip it if large (2mb zip allowed). If still too big can upload to fileshare site such as box.com and post link to file.

If you are trying to filter report to a specific employee, parameter has be to provided somehow. There are several approaches to this.

1. Input parameter prompt in query
I never use this method. Cannot validate user input.

2. Input parameter by reference to controls on form.
I seldom use this method.

3. Parameters input into form control passed to form or report with WHERE CONDITION of DoCmd.OpenForm (or OpenReport). I use this most often and I use only VBA, not macros, but I think macros can also do this.
DoCmd.OpenReport "report name", , , "Employee_ID=" & Me.formcontrolname

[smarty84handsome]

As you can see i don't like inputting parameter as well let me try Docmd in VBA usind Buildevent

[smarty84handsome]

Okay once i click code event in "click" and i modified the code as

DoCmd.OpenReport "Discprepancy_report", , , "Employee_ID=" & Me.formcontrolname

am i missing something it's giving me error saying "INVALID ME"

[orange]

It isn't clear exactly what you are trying to do.
Do you want to enter an employee number and only report that employee?
Why do you want parameters?

You could have a Form, and select employees etc to be reported; then a button to run the report using the "selected employees as part of the recordsource". (June7's option 3)

What exactly are you trying to accomplish?

[June7]

I don't know the name of your field or control so my example shows a generic "Employee_ID=" & Me.formcontrolname

Use the actual name of your field and form control.

Where are you putting this code?

Going in circles. Provide your project for analysis.

[smarty84handsome]

sir the reason i can't share the info is coz it's highly secured information in the data

[smarty84handsome]

okay here is where i am putting this code,

Open Repord Design View--->Emp ID (Label)--->Build Event (Code Builder) and in VBA mode on top left it says "TEXT39" and right hand part says "Click"

[June7]

Sounds like you might be in the VBA code editor but not sure what you are describing. The code would go behind a form not a report.

Don't care about data. Make copy, remove confidential data, a single dummy record can be helpful.

[smarty84handsome]

Sounds like you might be in the VBA code editor but not sure what you are describing. The code would go behind a form not a report.

Don't care about data. Make copy, remove confidential data, a single dummy record can be helpful.

Sir/Mam don't what it is but everytime i go through with you in this forum and i find solution myself. I guess u have a magic thouch i solved my problem and it's working perfectly. I appreciate your help.