A
Alasdair
Hi, I'm trying to add a form to my database to let me update a record
in another table. I have created the form using the wizard and added a
combo box on the field that I want to use to find the record; however,
everytime I pick the correct record, the associated information on the
form doesn't automatically change. I know this is dead simple, but I've
racked my brains and I can't remember hpw to do this. I have a table
with client names and information on it, and I want to have a form
based on this table where I can select the client name and the
associated client details would then change each time I selected a
different client name. If I wanted to update any part of the record eg.
telephone number, I would then use the form to update the record.
Trouble is, everytime I select a client, the table keeps the same
record information for the first client in the table and doesn't change
to the details attached to the client name I pick from my combo box.
Can anyone help ? Would be muchos appreciated!
in another table. I have created the form using the wizard and added a
combo box on the field that I want to use to find the record; however,
everytime I pick the correct record, the associated information on the
form doesn't automatically change. I know this is dead simple, but I've
racked my brains and I can't remember hpw to do this. I have a table
with client names and information on it, and I want to have a form
based on this table where I can select the client name and the
associated client details would then change each time I selected a
different client name. If I wanted to update any part of the record eg.
telephone number, I would then use the form to update the record.
Trouble is, everytime I select a client, the table keeps the same
record information for the first client in the table and doesn't change
to the details attached to the client name I pick from my combo box.
Can anyone help ? Would be muchos appreciated!