Member Avatar for mitsuevo
mitsuevo 0 Newbie Poster

hey,
I have a table say 'Student' and it has the regular fields and a PK called 'stNo'. I ahve made a form to view/enter data for this.
This is what I want it to do. When you enter a value into "stNo" if its not present in the table it will create a new record. But if it exisits, i want it to goto that current existing record. How can i arrange that to happen?
I included a "Find" button that pops up the normal windows/office search window, but thats a bit inconvinent.

Thanks!

  • 1 Contributor
  • 0 Replies
  • 76 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.