Selecting a record with a combo box

[jgoodman00]

I am trying to create a form which enables the user to select a record using a combo box. This bit is simple, but depending on what record the user chooses, will influence the data displayed. For this reason a form has been created for each data type. I have then used a select case statement on the after update of the combo box. This works to a point, in as much as it displays the correct subform. However, it does not display the corresponding record. To make things worse, it will only display one record for each data-type. This is because the combo box is bound by a codefeature number, which is used to detect which subform is required. As a result of this, it only displays tjhe first occurence of each codefeature data-type.

So does anyone know how I can resolve this issue, or another way in which i can select records & display the relevant form & data????

P.S. This is related with a question i posted in the Modules forum, because I am trying to set the LinkMasterFields dynamically depending on what codefeature was selected. I tried setting the LinkMasterField statically & this does not work, so I am doubtful that setting the LinkMasterField dynamically will work..... James Goodman
j.goodman00@btinternet.com

 

[jgoodman00]

I have now managed to display the correct informtion when LinkMasterFields & LinkChildFields are set statically. Now all I need to know is what the syntax is for setting this property. As I wrote in my question in the modules forum, Access help says it is possible, but i doesn't say how...... James Goodman
j.goodman00@btinternet.com

 

[braindead2]

Me![YoursubForm].LinkChildFields = "yourchildfield"
Me![YoursubForm].LinkMasterFields = "Your masterfield"