S
SPotter
I am creating a database using Access '97. I have a
table called "Supplier", for which there is a form I have
created of the same name. I have another table in the
same database called "Rating" and this too has an
associated form.
I want to be able to search through the records of
Supplier (from the form "Supplier"), then click on a
button, which opens the form "Rating", creating a new
record at the same time. "Rating" should then contain
the two fields "Supplier Name" and "Supplier ID" as they
appeared in the form "Supplier" on the record I was
viewing when the button was pressed.
The idea is that employees within my company would then
be able to rate various attributes of that supplier, with
the ratings they apply being specific to that employee,
the supplier and also the date. As such, it should
create a new record every time someone clicks the "Rate
this Supplier" button.
Now, I have managed to get Access to open the
form "Rating" and create a new record when the button is
pressed using simple macros. I have also managed to have
the supplier name and the supplier ID of the record in
the "Supplier" form transported to the Supplier Name and
Supplier ID fields in the "Rating" form. This I did by
changing the control source in the property box of the
supplier name and ID fields on the "Rating" form to
=[Forms]![Supplier]![Supplier Name],
and likewise for the ID.
However, when I close the "Rating" form, and subsequently
the "Supplier" form, and then re-open the "Rating" form I
find that the Supplier Name and ID have been replaced
by "#NAME?" throughout all of the records. Also,
the "Rating" table has no text whatsoever in those
fields.
How, then can I achieve what I am trying to do?
table called "Supplier", for which there is a form I have
created of the same name. I have another table in the
same database called "Rating" and this too has an
associated form.
I want to be able to search through the records of
Supplier (from the form "Supplier"), then click on a
button, which opens the form "Rating", creating a new
record at the same time. "Rating" should then contain
the two fields "Supplier Name" and "Supplier ID" as they
appeared in the form "Supplier" on the record I was
viewing when the button was pressed.
The idea is that employees within my company would then
be able to rate various attributes of that supplier, with
the ratings they apply being specific to that employee,
the supplier and also the date. As such, it should
create a new record every time someone clicks the "Rate
this Supplier" button.
Now, I have managed to get Access to open the
form "Rating" and create a new record when the button is
pressed using simple macros. I have also managed to have
the supplier name and the supplier ID of the record in
the "Supplier" form transported to the Supplier Name and
Supplier ID fields in the "Rating" form. This I did by
changing the control source in the property box of the
supplier name and ID fields on the "Rating" form to
=[Forms]![Supplier]![Supplier Name],
and likewise for the ID.
However, when I close the "Rating" form, and subsequently
the "Supplier" form, and then re-open the "Rating" form I
find that the Supplier Name and ID have been replaced
by "#NAME?" throughout all of the records. Also,
the "Rating" table has no text whatsoever in those
fields.
How, then can I achieve what I am trying to do?