mmayhew
04-15-2002, 12:14 PM
I am creating a form where I have two seperate fields. Both of these fields are set as combo boxes based on a table where I want the data to come from. One field is locked out because I would like for it to auto populate itself based on the users selection in the unlocked field. If I need to explain myself further please don't hesitate to tell me! Thanks for any help anyone can offer!
Tonyi
04-15-2002, 09:02 PM
Sounds like the open combo box is fine. It is the other you have problems with.
If both are from the same table, then normally you would be accessing the a single record, in which case a standard text box will display the contents of the record ascossiated with your selection in the combo box. To have the form look for the record ascossiated with the open combo box, select "Find a record....." when creating the combo.
If you wish to select data from different records of the same table, then you have an interesting structure. Perhaps another approach would be appropriate.
Cheers
vangogh228
04-19-2002, 07:03 AM
Tonyi: I have been trying to accomplish the same thing. Can you walk through the procedures? I have tried (almost) every procedure to accomplish this... and I KNOW it can be done. I've seen it. Thanks SO much!!!
vangogh228
04-20-2002, 02:28 AM
Check this thread. It may answer your question.
http://www.access-programmers.co.uk/ubb/Forum1/HTML/007967.html
If it does, thank Jenn.