Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in datasheet view based on query with list of open jobs. On
the main form that the query is pulling info from, there are six fields for
stages each job is in. I have it set up so if there is text in a field, the
next empty field pops up with messages for that stage. I would like to do
something with the same idea, but have the next empty field name show up in
maybe an unbound text box on the datasheet form so that we would know what
stage the job is in. Can this be done, and if so, how? Any help is very
much appreciated!
Thanks,
Phisaw
 
I have code that is working somewhat - though still not correct.

Private Sub Form_Open(Cancel As Integer)
If Not IsNull(Me.Receiving) Then
Me.txtJobStatus = "Disassembly"
ElseIf Not IsNull(Me.Disassembly) Then
Me.txtJobStatus = "Balancing"
ElseIf Not IsNull(Me.Balancing) Then
Me.txtJobStatus = "Machining"
End If
End Sub

As it stands, the four records this is applied to have text in "Receiving",
two are blank at "Disassembly" and two have text and these same two with text
also have text in "Balancing". Code returns in txtJobStatus "Disassembly"
for all. I have also tried the code with "Not" and changed fields around to
read appropriately, and have also tried placing the field in several other
events. I have read other posts and can't find anything to make this work.
Any help is greatly appreciated! Thanks, Phisaw
 
Back
Top