Problems with Combo Box

[jrabenhorst]

Hey Everyone... I'm using a combo box to locate a form and ultimately populate other fields, however I'm unable to type information in the combo box that might not already be in the list. When I type it into the box, Access accepts it until I attempt to jump to another record, Then I get a message that reads:

The Microsoft Jet Database Engine cannot find a record in the table 'Company' with key matching field(s) 'companyname.'

I've already played with the limit to list option in the properties menu, but with no luck. I'm trying to get the field to allow me to type information into the field without adding it to my table. What am I doing wrong?

 

[hceonetman]

jrabenhorst,
You may have to change the "limit to list" value in the design of the underlying table, not just in the form. Open the table in design view and click on the 'Lookup' tab for the field.

HCEONETMAN

 

[jrabenhorst]

It's listed as a text box in the underlying table, and a combo box in the form.