Default Value in Combo Box Not Visible

[alansidman]

In a form, I have a combo box that is has two values. "Vendor Claim" and "Carrier Claim". The user would like this combo to reflect a default value of "Vendor Claim." In the properties for the combo box, I have typed: ="Vendor Claim". However, the combo box remains blank. The underlying table has two fields. ID and Description. The Combo box is bound to the first field (ID) and the widths are set to 0";1". I have done a compact and repair. I have removed the combo box from the form in case it was corrupted and rebuilt the combo box. Same issue. It is really baffling me. Your thoughts on this??

Alan

[rpeare]

if the ID is the bound column wouldn't the default value be the PK of the "Vendor Claim" value and not the text itself?

[June7]

The = sign is not needed. Want to save ID or Description to the record? If saving ID, set the DefaultValue to the appropriate ID value (maybe 1 or 2).

[alansidman]

Thanks June and Rpeare. Changed the default to the ID value and Vendor Claim now appears as the default.

[June7]

Personally, I would just save the values "Vendor" or "Carrier" in text field and avoid the issues with lookup alias.

[alansidman]

June, I get it, but there is an underlying factor. The claim field actual begins with VC or LD followed by numbers. The criteria in the query then uses a Like statement to get the proper results. But it is working as designed and thanks for marking it "solved"