simonjackson79
Technical User
Hello again!!! I know I'm being a real pain today, but I'm sure this is the last thing I need to know.
I have setup a form with the fields [Unique ID], [Surname], [First Name] and [Date Of Birth]. What I need to know is what code to add to a button so that it searches on the data entered and opens the client form at the relevant record. ie. Sometimes the user won't know the Unique ID, and will maybe type in the just the Date of Birth and the Surname. How do I setup a search subroutine that will ignore null fields and just search on the fields with data in and open the form at the correct record?
Many thanks in advance!
Si
I have setup a form with the fields [Unique ID], [Surname], [First Name] and [Date Of Birth]. What I need to know is what code to add to a button so that it searches on the data entered and opens the client form at the relevant record. ie. Sometimes the user won't know the Unique ID, and will maybe type in the just the Date of Birth and the Surname. How do I setup a search subroutine that will ignore null fields and just search on the fields with data in and open the form at the correct record?
Many thanks in advance!
Si