S
serviceman
Hi all!
I'm a beginning Access 2003 user, and I'm having some trouble with combo
boxes. Here's my trouble:
I have a form where I want to edit or delete students from the table STUDENTS.
This table has an IDENTITY column (named IDENTITY), and it also has a
calculated column that concatenates FST_NAM(first name) and LST_NAM(last name)
; this column is named FULL_NAM(full name). This form also has a 'Delete
record' button. I have created a combobox(unbound) to look up records on the
form using FULL_NAM (Combo104).The problem is the way the combo box displays;
When I open the form the combo box text area is blank (this is ok), and the
list is populated correctly. When I select a record it displays fine, but if
I delete that record it stays in the text area of the combo box and in the
list as well. Through much trial and error I have gotten the list to update
by adding DoCmd.Requery "Combo104" to the code, but I cannot get the text
area to go to the next record, nor can I get the form to just clear
completely when I delete. Clearing the form and resetting the list would be
the preferred setup, but I'm L-O-S-T! I would also like to put a combo box on
the IDENTITY column that would function in the same way. ANY help would be
greatly appreciated!!! I would really like to get a better handle on Access,
as there are several daily tasks that I can make easier if I can just figure
it out!
Andy
I'm a beginning Access 2003 user, and I'm having some trouble with combo
boxes. Here's my trouble:
I have a form where I want to edit or delete students from the table STUDENTS.
This table has an IDENTITY column (named IDENTITY), and it also has a
calculated column that concatenates FST_NAM(first name) and LST_NAM(last name)
; this column is named FULL_NAM(full name). This form also has a 'Delete
record' button. I have created a combobox(unbound) to look up records on the
form using FULL_NAM (Combo104).The problem is the way the combo box displays;
When I open the form the combo box text area is blank (this is ok), and the
list is populated correctly. When I select a record it displays fine, but if
I delete that record it stays in the text area of the combo box and in the
list as well. Through much trial and error I have gotten the list to update
by adding DoCmd.Requery "Combo104" to the code, but I cannot get the text
area to go to the next record, nor can I get the form to just clear
completely when I delete. Clearing the form and resetting the list would be
the preferred setup, but I'm L-O-S-T! I would also like to put a combo box on
the IDENTITY column that would function in the same way. ANY help would be
greatly appreciated!!! I would really like to get a better handle on Access,
as there are several daily tasks that I can make easier if I can just figure
it out!
Andy