Find Record, Msgbox

[leecsone]

HI All

I am having a problem getting the find record buttion to work. I have a form with a findrecord button and a msgbox that I am useing to show a help message. Now when I use the findrecord button it works fine . The msgbox works fine also. But when I use the msgbox befor I use the findrecord button the findrecord button gets an error message. when I exit out and go back into the form I can use the finerecord button. But if I use the msgbox after useing the findrecord the findrecord get's a error message again.
can some HELP!!!

Leecsone

 

[missinglinq]

In order to help we really need to have some of the particulars. It ould help to have the code behind the find record button as well as the code for the message help box. It would also help to know what error code is being generated.

The Missinglinq

 

[leecsone]

Findrecord, Msgbox Button

HI missinglinq

The error message I am getting is this (YOU CAN'T USE FIND OR REPLACE NOW.

THE FIELDS ARE NOT SEARCHABL DO TO ONE OF THE FOLLOWING.

*The fields are controls(such as buttons or OLE objects)
*The fields have no data.
*Their are no fields to search.

Thank you for responding so fast.

leecsons

 

[Fizzio]

Post the VBA code that you are using for the messagebox and search.

 

[leecsone]

Findrecord, Msgbox Button

HI


I used the macros action for the msgbox, and findrecord.


Thank you for helping me.


leecsone

 

[Fizzio]

Ok then, post the statements and options you have in your macro (Good time to start learning VBA though!)

 

[leecsone]

Findrecord, Msgbox Button

Hi ALL


I have solved my problem.


Thank you all who assisted me.

leecsone