I have a multipart question I was hoping someone can help with. I have a form that is used as a Tracker. There are 6 steps in the business practice being tracked and the form (source is just one table) needs to be updated as each happen.
The form is set up where at each step there is a caption that states the step (ex Contract Submitted), followed by a text box for the user to enter their initials to sign off on that step, followed by a date text box, followed by a time text box.
I have set up the date and time text boxes enabled property to false. I have the date and time = Format(Now,"Medium Date"
as the afterupdate event in the initials text box. This all works great.
I need to set the form up so when the form is opened it is blank and someone can enter an existing tracking number(primary key) in the trackingno text box. If that number is in the table the rest of the fields that currently have info stored also come up. The time and date enabled properties are already set to false so they cant be changed unless someone updates the initials textbox at that step. If that step is already "signed off" I dont want this to be able to happen so now i need the initials text boxes at any step where there is data to also be not updateable. However, any step that hasn't been "signed off" yet, the user needs to be able to enter initials in that steps appropriate text box.
If the user initially enters a trackingno that is not currently in the table I think I want a text box displaying that and asking if they want to start a new record or if they hit no then just go back to the form so they can try again.
Thanks for any help, suggestions, code, ideas!!!!!
jh
The form is set up where at each step there is a caption that states the step (ex Contract Submitted), followed by a text box for the user to enter their initials to sign off on that step, followed by a date text box, followed by a time text box.
I have set up the date and time text boxes enabled property to false. I have the date and time = Format(Now,"Medium Date"
as the afterupdate event in the initials text box. This all works great. I need to set the form up so when the form is opened it is blank and someone can enter an existing tracking number(primary key) in the trackingno text box. If that number is in the table the rest of the fields that currently have info stored also come up. The time and date enabled properties are already set to false so they cant be changed unless someone updates the initials textbox at that step. If that step is already "signed off" I dont want this to be able to happen so now i need the initials text boxes at any step where there is data to also be not updateable. However, any step that hasn't been "signed off" yet, the user needs to be able to enter initials in that steps appropriate text box.
If the user initially enters a trackingno that is not currently in the table I think I want a text box displaying that and asking if they want to start a new record or if they hit no then just go back to the form so they can try again.
Thanks for any help, suggestions, code, ideas!!!!!
jh