I have a function that creates a temporary recordset by checking whether a field on the current form has a matching field in a different table. If there is a matching field, the function returns true, otherwise it returns false.
Presently, my form simply changes the background color of the field on the form when the function returns true. What I would like to do is provide the user with the option to view the complete contents of the temporary recordset, if they so choose. For example, if the user notices that the field has changed color, they should be able to double-click the field to be able to display the temporary recordset and view all fields of the matching record in the other table. Here is the current code:
Private Function SaleRollExists(CurrentRoll As String) As Boolean
Dim rs1
Dim strQuery As String
strQuery = "SELECT * from [tblSales] where [SingleRoll]='" & CurrentRoll & "'"
Set rs1 = [login to view URL](strQuery)
If [login to view URL] > 0 Then
SaleRollExists = True
Else
SaleRollExists = False
End If
[login to view URL]
Set rs1 = Nothing
End Function
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
winxp/access2002