Auto Updating list box after print

[jbaccess]

Not sure if I'm in the right area but here goes...


I have two tables [Transaction Types] and [Inventory Transactions], that are linked through [Inventory Transactions Extended query].


When I print a "Load / Shipper" report based on the [Inventory Transactions Extended].[Shipper ID], I'd like for the [Transaction Type].[Description] to then automatically update to a specific stage for all of the appropriate records (the shipper id)

The transasction type currently is a drop down list box and has seven choices
1) add to inventory
2) Work In Process
3) Load / Shipper
4) Selected for Bid
5) Ready for Invoicing
6) Invoiced
7) Paid in Full and
8) Partial Payment

We can have more than 40 records tied to a single shipper, thus we do a lot of batch processesing. I am trying to eliminate human data entry errors. What is the best way to set this up?

 

[jbaccess]

Re: Auto Updating list box

Private Sub Date_RFI_GotFocus()
If Len([Date_RFI] & "") <> 0 Then
Me.[Transaction_Type] = 6
End If
End Sub

Private Sub Shiper_ID_GotFocus()
If Len([Shiper_ID] & "") <> 0 Then
Me.[Transaction_Type] = 3
Else
Me.[Transaction_Type] = 1
End If
End Sub


Is the code that I'm using which does make the change for the Shiper ID Got Focus, but the Date RFI is not working.... any suggestions?

 

[jbaccess]

Working now... with the above code... wierd.