Showing a textbox based on a query result
I have an access table that holds customer information and another table that holds orders associated with those customers. I want to place a textbox on the form that is used to enter customer information that alerts the salesperson if there is an order associated with that customer based on matching a customer number between those two tables. So, if there are no orders the textbox is blank, but if there are turn it red and display some text. If there are orders I want to show a button that I will use to open a form to show those orders.
I know enough about access to create the queries and forms and such, but I don't know how to change the behaviour of a textbox based on the results of a query.
I know enough about access to create the queries and forms and such, but I don't know how to change the behaviour of a textbox based on the results of a query.
You can use dlookup for searching records for this customer and if returned falue (records count, for example) >0 set text and color of textbox
ASKER
We're getting closer, the customer number will already be on the form where the alert will be shown ( I know I said textbox in my first post, but I don't know what is more appropirate to show an alert, a textbox or a label) , tblCustomer.CustomerNumber
is CustomerNumber field Text Or Number data type?
what is the name of the textbox for the CustomerNumber?
a label or textbox will do.
what is the name of the textbox for the CustomerNumber?
a label or textbox will do.
ASKER
It is a number field, the textbox that houses the customer number is CustNumTextBox
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can use dlookup() or dCount() functions to check if records exists for a customer..
in the afterupdate event of the textbox where you enter customer number
private sub txtcustomer_afterupdate()
if dcount("*","tableName","cu
me.YourNEWTextbox.backcolo
end if
end sub