Hello,
I am wondering if there is anyway to reset the form to intial load view. I have a form which has a record source of an exsiting query. This forms allows a user to place a device on repair. Also when a user tabs to the second field (SerialNum) and enters a valid serial it populates another field (PID) automatically .
What I am trying to do is if the Serial is valid, then the user checks a box to place it on repair but I obviuosly dont want them to do this if its already placed on repair. I have placed a procedure to take the serialnum and check the table to see if its on repair. If so then it instructs the user to first fill out the service information(on another form) and take it off of repair. After this message displays I want to have the fields that are bound b/c of the forms record souuce cleared just has when the user first opens the form as well as stop it from making a entry in the repair table. Any suggestions would help. Should I have intially created a record set and then updated the tables according? Would this be more efficient? I am hoping I wont have to do this but if its a better way then I will. Oh almost forgot the first database was split. One holds the forms which its tables are linked to another that holds the tables.
Thanks any help and I hope it wasnt to lengthy!
I am wondering if there is anyway to reset the form to intial load view. I have a form which has a record source of an exsiting query. This forms allows a user to place a device on repair. Also when a user tabs to the second field (SerialNum) and enters a valid serial it populates another field (PID) automatically .
What I am trying to do is if the Serial is valid, then the user checks a box to place it on repair but I obviuosly dont want them to do this if its already placed on repair. I have placed a procedure to take the serialnum and check the table to see if its on repair. If so then it instructs the user to first fill out the service information(on another form) and take it off of repair. After this message displays I want to have the fields that are bound b/c of the forms record souuce cleared just has when the user first opens the form as well as stop it from making a entry in the repair table. Any suggestions would help. Should I have intially created a record set and then updated the tables according? Would this be more efficient? I am hoping I wont have to do this but if its a better way then I will. Oh almost forgot the first database was split. One holds the forms which its tables are linked to another that holds the tables.
Thanks any help and I hope it wasnt to lengthy!
