Hello,
I am not sure this is possible but I am trying to do something on one of my input forms. I want to display a Customer Name from a different table when a value is input into the form. Conceptually this is what I am trying to do:
Acct # : Blank input form that the customer inputs
Customer Name: Automatically found based on the above Acct #... The SQL would be Select Customer_Name from NonCoreCustomers where Noncorecustomers.Acct = me.acct
Here is the VBA I have been trying to do:
Dim sSql As String
sSql = "SELECT noncorecustomers.[customername] " & _
"FROM noncorecustomers " & _
"WHERE noncorecustomers.acct='" & Me.acct.Value & "';"
I am not sure how to show this value. If there is another way I am open to options. The main goal here is being able to display a value from another table that is linked based on PKs in the form.
Thanks guys!