KevinSlater
Registered User.
- Local time
- Today, 23:40
- Joined
- Aug 5, 2005
- Messages
- 249
Hi all, I have 2 tables, “DATA-CUSTOMER” and “DATA-MAIN”
“DATA-CUSTOMER” has the following fields:
Rep_code, Area_code, Name, Update (yes/no)
“DATA-MAIN” has the following fields:
Rep_code, Area_code, Name
I have a form which has 3 combo boxes, looking at the following fields: rep code, area code, name,. These combo boxes are picking the data up from querys which look at the table: “DATA-CUSTOMER”
I am trying to enable the user to select from the 3 combo boxes these 3 fields and it should update the table “DATA_MAIN” with these details. It appears to update the "DATA-MAIN" with one record but keeps overwritting the first record, and the combo fields in the form already have fields selected, i would like them to start of blank when entering the form.
Any help would be appreciated, attached is test database that I cant get to work properly.
cheers, Kevin
“DATA-CUSTOMER” has the following fields:
Rep_code, Area_code, Name, Update (yes/no)
“DATA-MAIN” has the following fields:
Rep_code, Area_code, Name
I have a form which has 3 combo boxes, looking at the following fields: rep code, area code, name,. These combo boxes are picking the data up from querys which look at the table: “DATA-CUSTOMER”
I am trying to enable the user to select from the 3 combo boxes these 3 fields and it should update the table “DATA_MAIN” with these details. It appears to update the "DATA-MAIN" with one record but keeps overwritting the first record, and the combo fields in the form already have fields selected, i would like them to start of blank when entering the form.
Any help would be appreciated, attached is test database that I cant get to work properly.
cheers, Kevin
Attachments
Last edited: