combo box problems

[metokushika]

hi!



i have a form with
a combo box that
is saved to a table
that serves as my
database.


i'm having problems


with the combo box cuz
when i fill up the form
and when i press the
'save' button, it
saves to the table
but when i close the
form and open it again,
when i view the records,
the text on the combo
box are all the same.



it's like it shows the last
record. but in the table,
the names are saved except
that when you view it on the
form, only the last record
shows on the combo box for
all forms.

how can i solve this?

[pdebaets]

What is the ControlSource property of the ComboBox set to? It should be bound to a field in your table.

What is the code behind your Save button?

[metokushika]

the "rowsource" in my
combo box's properties
is like this:
SELECT [RegularRate], [Employee] FROM SupraSetterEmp;
which means, i want to get
the regular rate and the name of
the employee from the "suprasetteremp" table.

and the save button is from
the access itself.

now my problem is,
when i enter a new record
to the form, as i choose
an employee from the combo box,
it does save. BUT when
i close the form and open it again,
the combo box only shows the
last record. let's say, i made
5 records on the form, when
i view each of them, the combo
box keep showing the same names.


although when i view it on the table,
it doesn't. i'm just having problems with
the combo box.



pls help pls help!


thanks again,
kiera