compile error invalid use of property

[PoojaJyoti]

Hi,
When I write code
txtFirstName.te xt=rstKrish("Fi rstName")
compiler highlighted .text and error describes method or data member not found.
Please help

[Killer42]

When I write code
txtFirstName.te xt=rstKrish("Fi rstName")
compiler highlighted .text and error describes method or data member not found.

Please give us some context. for example...

• What version of VB is this?
• What is txtFirstName?

Assuming it's a textbox, is this code within the same form? If not, you probably need to use a syntax something like YourFormName.txtFirstName.T ext to access this value.

[willakawill]

You should continue your questions on the same thread rather than starting a new one each time your code doesn't work. I have closed the original thread and this is a link to it

[PoojaJyoti]

Please give us some context. for example...

• What version of VB is this?
• What is txtFirstName?

Assuming it's a textbox, is this code within the same form? If not, you probably need to use a syntax something like YourFormName.txtFirstName.T ext to access this value.

I have used Visual Basic 6.0 and txtFirstName is textbox

[vijaydiwakar]

Hi,
When I write code
txtFirstName.te xt=rstKrish("Fi rstName")
compiler highlighted .text and error describes method or data member not found.
Please help

check first the column name of recordset is spelled correct then check it doen't contain any null value to avoid this use this code
txt.text=Rs0("F irstName") &""
try it

[Killer42]

check first the column name of recordset is spelled correct then check it doen't contain any null value to avoid this use this code
txt.text=Rs0("F irstName") &""

Or, as a first step in debugging, comment out the existing line and replace it with...

txtFirstName.text = "A"

This will determine for certain whether the problem lies with the database field or the textbox. My money would be on the latter.

If the textbox is the problem, then chances are it is simply out of scope. For example, your code might be on a different form, or in a code module rather than a form. If that's the case, then you need to identify the form that it lives on - see my earlier post for details.

On the other hand, are you certain it's a textbox? And not, for example, a label?