Hi Guys
I have seen similar issues around but not been able to fins anything that works.
The issue i currently have is with creating the navigation buttons between forms and their functionality.
My table is named tblUserInfo
and the two forms are Form1 and Form2
On the welcome form i want to insert a button which is coded to do the following when a user enters their ID:
1) Request the user to enter their ID
2) Check the user ID against others already in the database to determine if they an entry has already been made.
3) If an entry has been made then a Form2 opens with all the relevant boxes already completed.
4) If the search finds entry then Form2 opens with no data involved.
I have been trying lost of different codes but am not sure how to code the searches.
I have been able to write the code for the new record.
Any assistance will be greatly appreciated!!
Thanks in advance
I have seen similar issues around but not been able to fins anything that works.
The issue i currently have is with creating the navigation buttons between forms and their functionality.
My table is named tblUserInfo
and the two forms are Form1 and Form2
On the welcome form i want to insert a button which is coded to do the following when a user enters their ID:
1) Request the user to enter their ID
2) Check the user ID against others already in the database to determine if they an entry has already been made.
3) If an entry has been made then a Form2 opens with all the relevant boxes already completed.
4) If the search finds entry then Form2 opens with no data involved.
I have been trying lost of different codes but am not sure how to code the searches.
I have been able to write the code for the new record.
Any assistance will be greatly appreciated!!
Thanks in advance
