Search results for query: *

DISREGARD PREVIOUS POSTS. I figure out what is going on. The table is being updated with the primary key field. Instead of getting the customer Id or Item ID, I am getting the corresponding ID numbers (first column, primary key- auto number)for the corresponding record. What do I need to do to...

To answer your questions: 1 - My bad. I was trying to get the customer ID combo box selection to update the address field in the list box below with the corresponding information. I concatenated all the address fields to this field and by mistake bound it to the same field as the combo box...

jaydeebe, Tried yor suggestion but getting an error. Just so you know, on this step I am just trying to update only the customer ID, if it works, I will copy the logic to the address and item id boxes. Below is the info that I pasted: Public Sub Combo97_AfterUpdate() DoCmd.RunSQL "INSERT INTO...

Customer ID combo box Control source - Customer-ID Row source - SELECT CUSTOMER.ID, CUSTOMER.[Customer ID] FROM CUSTOMER; Bound column - 1 Column widths - 0";1" Customer Address list box: Control source - Customer-ID Row source - SELECT CUSTOMER.ID, CUSTOMER.[Ship to Name 1] & " " &...

I created a form for data entry into a table. The form, among other fields, contains three fields as combo boxes. Such fields (customer ID, address and Item ID) are queried from two separate tables (Item and Customer). The problem that I am having is that any time I enter a record into the table...