query not working by changing field type from number to text

[rehanemis]

Hi,
I have changed the data type of field "EmpID" from number to text and the query not working now. Any suggestion?

 

[MajP]

you need to wrap strings in single quotes
"EmpID = '" & screen.actvieControl & "'"

 

[cheekybuddha]

"[EmpID] = '" & Nz([Screen].[ActiveControl], 0) & "'"

 

[rehanemis]

you need to wrap strings in single quotes
"EmpID = '" & screen.actvieControl & "'"

It saying type mismatch when I select a record.

 

[rehanemis]

"[EmpID] = '" & Nz([Screen].[ActiveControl], 0) & "'"

type mismatch error

 

[cheekybuddha]

What is the RowSource of cboSearch?

What are your table fields and their datatypes?

 

[rehanemis]

What is the RowSource of cboSearch?

What are your table fields and their datatypes?

Rowsource from table field of text type.

 

[rehanemis]

I want to show the relevant records in subform by choosing the EmpID from drop down. It was working well on numeric data type but not on text.

 

[cheekybuddha]

I never use macros, so I'm not familiar with the double = signs that you showed in your first image.

Did you replicate them in your adjusted expression based on the suggestions from majp and myself?

Please post the expression you have now. (Please copy and paste, don't post an image)

Is there any reason you're not using code instead?

 

[cheekybuddha]

Also, why did you change from number to text?

 

[rehanemis]

I never use macros, so I'm not familiar with the double = signs that you showed in your first image.

Did you replicate them in your adjusted expression based on the suggestions from majp and myself?

Please post the expression you have now. (Please copy and paste, don't post an image)

Is there any reason you're not using code instead?

="[EmpID] ='" & Str(Nz([Screen].[ActiveControl],0) & "'")

I am not much familiar with code to search record in subform.

 

[rehanemis]

Also, why did you change from number to text?

Yes, I changed the type from number to Text.

 

[cheekybuddha]

Shouldn't you have the subform name in the Object field?

 

[rehanemis]

Shouldn't you have the subform name in the Object field?

No. it don't have.

 

[rehanemis]

you need to wrap strings in single quotes
"EmpID = '" & screen.actvieControl & "'"

type mismatch error.

 

[cheekybuddha]

What is the name of your subform control?

(Note, this might be different from the name of the actual subform used as its SourceObject)

 

[rehanemis]

The subform name is: "frm_Reports_lRecallSheetStatus"

 

[cheekybuddha]

I'll have to get back to you tomorrow. It's late here.

Someone else might pick up the pace in the meanwhile

 

[rehanemis]

I'll have to get back to you tomorrow. It's late here.

Someone else might pick up the pace in the meanwhile

Thanks for your time. Have a good night.

 

[zeroaccess]

None of this would be necessary if using link Master and Child fields in the subform properties. Look on the Data tab.

But...if you insist on using search for record (not necessary)

The macro builder helps you by suggesting field names when you begin typing. I would just double click those.

Also, I specify the actual field name rather than relying on ActiveControl. I don't know if it would ever cause a problem, but what would happen if that control suddenly wasn't active?

Try

="[EmpID] =" & [EmpID]