Update table from form

[Guest]

Using Access 2007 (badly.) I inherited a DB and need to add a combo box to a
form. There are already 3 combo boxes on this form, that successfully update
three individual tables with appropriate data selected from a textbox list.
The new combo box I've added for a similar purpose won't allow me update the
table.

As far as I can see, the properties for this new box are identical to the
properties for the working boxes. I can update the table manually with the
required data just fine, so I know it's something on my form.

The combo box goes to a very simple table: L_GameType, with 2 fields:
Game_TypeID and GameType. Game_TypeID is one of two text items: R or S. The
Row Source for this combo box is:
SELECT L_Game_Type.Game_Type_ID, L_Game_Type.Game_Type
FROM L_Game_Type;
It's bound to column 1 and limit to list is yes.

Form behavior is, I can pull down the short list but I can't select an
option with the mouse. The other combo boxes work just fine.

Sorry for such a basic question -- I'm just not familiar with Access 2007 at
all and barely know my way around earlier versions to begin with.

Thanks,

 

[Hunter57 via AccessMonster.com]

Hi Jacy,

Your SQL does not match your table field. You say your Table field is
Game_TypeID but your SQL in your Row Source has Game_Type_ID. Is this just a
typo in your post or is that how your Table Field and SQL Statement are set
up?

Hunter57
http://easymsaccess.blogspot.com (Simple Access Tips)
http://www.ChurchManageSoftware.com

 

[Guest]

That's a typo in my post, verry sorry!

 

[Hunter57 via AccessMonster.com]

Hi Jacy,

You need to carefully check the settings of your Combo Box's Properties Sheet.


Click on the Data tab. Make sure that "Enabled" is set to "Yes" and "Locked"
is set to "No". Make sure that Validation Rule is blank. The same goes for
Input Mask. Check to make sure your Control Source is the correct field.
You can temporaritly remove the setting there (making it an unbound Combo Box)
and see if it puts the value in your Combo Box. If it works when you do that
then you probably have some setting wrong in your Combo Box's Properties
Sheet.

Click on the Format tab and make sure your Column Count is set to 2. Check
your Column Widths and make sure there are 2 of them like this: 1";0.7" or
some other widths. Clear anything you find in the Format Property.

Hope you find a solution,
Hunter57
http://easymsaccess.blogspot.com (Simple Access Tips)
http://www.ChurchManageSoftware.com