Combo Box not passing on Parameter Value

[KiraMcD]

I have a subform with three combo boxes. After the user populates the boxes, they click a SAVE button. The first two combo boxes properly pass on their values. The third causes a MsgBox to popup asking ENTER PARAMETER VALUE - First (or Second or Third or Fourth depending on which value I've selected).

The third combo is populated from a simple table called tblChoice. (I originally used a value list, as there are only four choices, but I changed it to a Table thinking that was the problem. Needless to say it didn't fix the problem.) When you tab into that box you can see the four choices and select one of them. The MsgBox changes to reflect the option that's chosen.

I'm sure it's something very basic and I'm just not seeing it. TIA~

 

[LittleSmudge]

Check which column of your combo box is the BoundColumn

Is the data in that column consistent with the data type of the field you want to store the data in?

Is the combo box Bound or are you storeing the data some other way ?


It sounds very much like you have some sort of UnBound setup and you are storing the data using a recordset or ADO approach, but you have an unwanted set of braces in the code so it is trying to use the data it gets from the combo box as the name of a variable rather than the data itself.


If the above don't give you enough clues to fix it - post back the combo's RowSource SQL string and any code that you use to save the data.

That might give us a clue to the cause of the problem.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[grtammi]

Also, if you have a parameter value warning - it may be that a field was misspelled correctly.

Check your save subroutine / function and make sure all field names and table references have been spelled correctly.

Greg Tammi, IT Design & Consultation
Work:

http://www.atsbell.com

Home:

http://members.shaw.ca/gregandliz

 

[KiraMcD]

RESOLVED

Seems I was missing a couple of single quote marks around my Choice combo box. Silly me.

Thanks everyone for your help.

KM