Combo box entry in form to table...

[rupes_mahal]

Hi..

I have a form which has a combo box. The combo box has a drop down menu, with names in it. Once a name is choosen, the related text boxes get updated.

E.g.....
Text Boxes: 'Name' 'Address' 'Telephone'

Combo Box: 'Name'

When I pick a name from the combo box the 'Address' and 'Telephone' text boxes get updated. All working fine.

BUT

When I look in the table, the information is not displayed. The Name is displayed in the name field, but nothing appears in the Address and Telephone fields. But you can see it on the form. I need the fields in the table to also be updated with the address and telephone.

What am I doing wrong.....?

Please help....

Thank you in advance.

Ruby

 

[LQ]

Are the Address and Telephone fields bound to the underlying query or table? If they are unbound, they will not update the table (without some code, that is).

HTH

LQ

 

[rupes_mahal]

Hi LQ...

Thanks for replying.

The fields are bound to a table.

On the form in design view, the 'Address' text box says: DoctorsDetailsTBL.Address and DoctorsDetailsTBL.Telephone.

The code I am inserting in the properties, After Update =

Me!Address = Me!Addresses

this means, Me!Address = the table field name
and Me!Addresses = the text box name.

This doesn't work, error message appears:

Run-time error '2465'
Microsft Access can't find the 'Address' referred to in your expression.

Please help...what am I doing wrong.

Thank you in advance

Ruby

 

[LQ]

This topic from a few days ago might be helpful....
http://www.access-programmers.co.uk/ubb/Forum4/HTML/004139.html

If not, then post back with more detail on how your combobox is populating the Address and Telephone fields.

LQ