Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NEED A SIMPLE FORM TO UPDATE RECORS

Status
Not open for further replies.

HerickP

IS-IT--Management
May 10, 2000
68
US
Hi,<br><br>Anyone knows how to code or the code to a form where it will update two fields in a table, using 3 texboxes: Here is how it should work:<br><br>-First texbox: The user will imput a PO number; this PO already exists in the table, but Access should search this po in the table, then, validate; if its not valid, it should display a box like &quot;PO not Found&quot;; if found, then:<br><br>- The remaining 2 texboxes will be used to imput a Status, and a date received, particular to the PO that was searched earlier.<br><br>Do u guys understand? Can it be done without using the findrecord feature in access ( which sucks btw) Help!!
 
Missed the last part:<br><br>LAst, it would have a command button to update the records. thanks!!
 
see bookmark property example in Access help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top