want to set focus in find

[Matt]

I have a command button for find record. I want to get the find button to set
focus on the form to invoice number only, any ideas on the syntax for code in
VBA? Cheers!

 

[MacDermott]

Something like this?
Me.[Invoice Number].SetFocus
before your Find code.

 

[Matt]

Thanks MacDermott totally sorted it! i had the coding right just didnt use
the square brackets!
thanks again
Matt

Something like this?
Me.[Invoice Number].SetFocus
before your Find code.

I have a command button for find record. I want to get the find button to set
focus on the form to invoice number only, any ideas on the syntax for code in
VBA? Cheers!

 

[Alex White MCDBA MCSE]

Point to note in your naming convention the use of spaces can make things
more difficult for you in future use the _ instead of space then you don't
need the [ ]

e.g. Invoice_Number

there are systems out there that cannot read the space properly.



--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

Thanks MacDermott totally sorted it! i had the coding right just didnt use
the square brackets!
thanks again
Matt

Something like this?
Me.[Invoice Number].SetFocus
before your Find code.

I have a command button for find record. I want to get the find button
to set
focus on the form to invoice number only, any ideas on the syntax for
code in
VBA? Cheers!

 

[Matt]

Thanks Alex but that was his example i dont use spaces and had it set to
InvoiceNo thanks for the tip anyway!
Matt

Point to note in your naming convention the use of spaces can make things
more difficult for you in future use the _ instead of space then you don't
need the [ ]

e.g. Invoice_Number

there are systems out there that cannot read the space properly.



--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

Thanks MacDermott totally sorted it! i had the coding right just didnt use
the square brackets!
thanks again
Matt

Something like this?
Me.[Invoice Number].SetFocus
before your Find code.


I have a command button for find record. I want to get the find button
to
set
focus on the form to invoice number only, any ideas on the syntax for
code
in
VBA? Cheers!