Can't use FindRecord Macro

[pixadecavalo]

Hi everyone,



Trying to use a simple macro but can seem to make it work.

Macro: SearchForRecord
Where condition: [ID]=[Forms]![Form1]![TextBox1]

Try's to search but never returns the ID value of TextBox1

Probably would work with VBA but already have a lot of macros working together.

Any suggestions?

Thank you!

[CJ_London]

Looks like you are missing a couple of !

[pixadecavalo]

Sorry, I have then on my macro, forgot to put them here

[CJ_London]

I don't use macro's so can only suggest the usual:

is the event where you have this code firing?
is form1 open and spelt correctly?
is TextBox1 spelt correctly?
does the field ID exist in the recordsource?
does the value entered in textbox1 actually exist in your ID data?

Recommend you give objects meaningful names. Looks like you are using the default names on creation - except textbox1.

[pixadecavalo]

is the event where you have this code firing? Yes, its onClick of a button
is form1 open and spelt correctly? Yes
is TextBox1 spelt correctly? Yes
does the field ID exist in the recordsource? Yes
does the value entered in textbox1 actually exist in your ID data? If I change to [ID]=11 it works, if I use [ID]=[Forms]![Form1]![TextBox1] and insert 11 on the Text box, it doesn't work.
Even changed the text box data type to numeric on both to try and solve it

[CJ_London]

well, as I said, I don't use macros so unable to help further. Suggest you try VBA, it has much better functionality for debugging

[Welshgasman]

My Search For A record looks nothing like that?

[pixadecavalo]

It´s the same, my question is on the "where condition" field

[davegri]

This works for me. Looks odd but be sure first 2 equals are present.

[pixadecavalo]

@davegri, absolute legend, thank you very much!

[davegri]

@davegri, absolute legend, thank you very much!

Glad to help and thanks for the star!!