D
deviner
ive got 2 tables, a books table and loansd table. In my
loans form, i have details such as onloan. which is a pull
down menu which says yes or no, and then below that the
detaisl of theperson who has taken the book out if it is
onloan.i also created a list box at the top of my form,
which i created from my books table, and there are 50
records in this table. on the form i just scroll down the
list and select the book whose status details im filling
in. the problem is that when i fill in a record, the book
details in the list box arent saving. eg if i scroll down
to the 3rd record in the list box, eg moby dick, published
1960, author p bates and then proceed to fill in its status
(whether its on loan, and if so then loanees details) and
go to the next record, the list box is still on the record
ive selected previously, moby dick. the problem seems to
be that whatever selection i make in the list box then
this is the same in every record, as in the example
whenever i selected moby dick, that was in all 50 records,
and wasnt designated to the one record that i wanted. any
help would be grately appreciated!
loans form, i have details such as onloan. which is a pull
down menu which says yes or no, and then below that the
detaisl of theperson who has taken the book out if it is
onloan.i also created a list box at the top of my form,
which i created from my books table, and there are 50
records in this table. on the form i just scroll down the
list and select the book whose status details im filling
in. the problem is that when i fill in a record, the book
details in the list box arent saving. eg if i scroll down
to the 3rd record in the list box, eg moby dick, published
1960, author p bates and then proceed to fill in its status
(whether its on loan, and if so then loanees details) and
go to the next record, the list box is still on the record
ive selected previously, moby dick. the problem seems to
be that whatever selection i make in the list box then
this is the same in every record, as in the example
whenever i selected moby dick, that was in all 50 records,
and wasnt designated to the one record that i wanted. any
help would be grately appreciated!