Combo Box

[moleary]

I have asked this question before but I still am having trouble with it so I am sorry! I have a form with a combo box and two command buttons one that will take you to intake forms and the other to assessment information, now what I want to do is have the person pick a name from the combo box and be able to click on the command button to that person's specific form be it the assesment or intake form....but I can't seem to get this to work! Please help!

 

[Travis]

Part of the Docmd.OpenForm is a Filter that when set should limit the form to the particular record.

 

[moleary]

I am sorry I am not understanding what you are saying?

 

[LQ]

Check out this recent thread for an example of what Travis means.
http://www.access-programmers.co.uk/ubb/Forum4/HTML/004987.html

You can also look up the OpenForm method in the help files.

 

[Jack Cowley]

Another way to do this is to make a new command button to open the form using the Wizard. One of the questions that you will be asked is if you want to open the form showing all the records or a specific record. Select the Specific Record radio button then follow the rest of the screens. Besure and select the Combo box as the field in the current form and the related ID in the form to open.

 

[moleary]

jack,

I tried what you suggested but it still is not working it will only pull up a blank intake form??? any other suggestions???

 

[Jack Cowley]

What do you mean when you say 'blank' form? A form with no fields or are all the fields empty?. If you have empty fields look to see if you have Data Entry set to Yes in the Forms property sheet.

[This message has been edited by Jack Cowley (edited 11-29-2001).]

 

[jwindon]

Could it be also that maybe the "value" in the combo box is NOT [ID].....that the "bound" field is NOT the column of data in the combo that has the value for [ID]? Do you have a NameID and Name field (two columns) in your combo?



[This message has been edited by jwindon (edited 11-29-2001).]