Hello. I have a form and on the form it has several text boxes which list of the current records information such as First Name, Last Name, etc. The form's RecordSource is set to my client data table. So it brings up the current record's information in all of the different fields. You can then you the record selector buttons to navigate from record to record. This works just fine for updating client information and etc.
But now I need to add a comobo box to this form. The combo box's record source is set to an SQL statement to select all of the names of all the different sales people. I have the Control Source of the combo box set to the field that I'd like updated.
Real world explanation here. Initially when you bring up this form it will already have the clients information on it. The 'SalesPerson' combo box will be there, but will be blank initially. I need that combo box to have in it the list of all the sales people. Within the client table there is a 'SalesPersonAssigned' field that I want to be updated. So you bring up a client, you use the drop box to choose the sales person that's assigned, and when you click on the little arrow to go to the next record it saves the sales person information to the Client table. I'm trying to just use access on this, and not VBA, unless I have to.
The way I have it set up now, it does work, HOWEVER, when you move the record selector to the next record, it keeps the SalesPerson box set to what I just used for the previous client. So it's almost as if it's updating the entire table some how. I'd like it to be blank when I bring up the next record. More accurately, I'd like it to be set to that person's sales person. And if their sales person field is blank, then I want the combo box to be blank.
So does anyone know the proper way to do this? Let me know if you need more details or an explanation. It's hard to explain...
But now I need to add a comobo box to this form. The combo box's record source is set to an SQL statement to select all of the names of all the different sales people. I have the Control Source of the combo box set to the field that I'd like updated.
Real world explanation here. Initially when you bring up this form it will already have the clients information on it. The 'SalesPerson' combo box will be there, but will be blank initially. I need that combo box to have in it the list of all the sales people. Within the client table there is a 'SalesPersonAssigned' field that I want to be updated. So you bring up a client, you use the drop box to choose the sales person that's assigned, and when you click on the little arrow to go to the next record it saves the sales person information to the Client table. I'm trying to just use access on this, and not VBA, unless I have to.
The way I have it set up now, it does work, HOWEVER, when you move the record selector to the next record, it keeps the SalesPerson box set to what I just used for the previous client. So it's almost as if it's updating the entire table some how. I'd like it to be blank when I bring up the next record. More accurately, I'd like it to be set to that person's sales person. And if their sales person field is blank, then I want the combo box to be blank.
So does anyone know the proper way to do this? Let me know if you need more details or an explanation. It's hard to explain...