Stupid (and Hopefully Simple) Question on Editing Table from a form

[JJordan]

I want a User to be able to edit records in the Contacts database by selecting the ContactID, FirstNAme, LastNAme from a combo box and when that happens, it pulls up the information for that and the ComboBox come from the same and table come from and it does nto seem to work. I cannot seem to make it work. You have to scoll through the contacts to get to the one you want to edit.

Table is IndContacts.

 

[ColinEssex]

Can you not use the ComboBox wizard to create the combo and make the form open when a selection is made?

Col

 

[JJordan]

I have to confess I do not know what you mean because I know so little about what I am doing I can make a combo box with the Combobox wizard which selects as follows:

IndContacts.ContacID, IndContacts.[Last Name], IndContacts.[First Name]and in the Wizard, I can select the ContactID as the value to "store"

Now in the same form, I want to add all the fields from the IndContacts table and have them bound to that ContactID. That is what I have not been able to figure out. When I try to do it, I can make the combobox change if I change the record (go from 1 to 2 to 3 to 4 and the box at the top changes. I cannot do the opposite and make the Record change so the fields match the ContactID in the Combo Box.

 

[ColinEssex]

Hi

Unless I am reading your post completely wrong - I think you are wanting to have the form display the record os the name you select in the ComboBox.

If so - when you create the combo from the wizard, select the 3rd option "Find a record based on selection etc etc". This will then display the record ready for editing.

Post back if I'm on the wrong road

Col

 

[JJordan]

Thanks. I knew it was easy and I was just MISSING it. I