Please help me!
I have a SQL database and I have created a DBcombo box on a form for a UserID (this is a unique value). This works fine and all IDs are displayed.
Also on the form I have other fields that relate to the UserID from the table in the database (Name, address etc...). How do I get the fields to update to display the correct information when I select an ID from the combo box? I am a newbie, so please forgive my ignorance if this is easy, but I am trying hard!
Thanks for your help! Kate
I have a SQL database and I have created a DBcombo box on a form for a UserID (this is a unique value). This works fine and all IDs are displayed.
Also on the form I have other fields that relate to the UserID from the table in the database (Name, address etc...). How do I get the fields to update to display the correct information when I select an ID from the combo box? I am a newbie, so please forgive my ignorance if this is easy, but I am trying hard!
Thanks for your help! Kate