Reply to thread

Message: [QUOTE="John W. Vinson/MVP, post: 12304785"] See [URL]http://www.mvps.org.access/lookupfields.htm[/URL] for a critique of the Lookup Field misfeature. It is NOT necessary to create a lookup field to do what you ask. A Combo Box should get data from one table (its Row Source) and put it into a different table. To be precise, it should put one field - the Bound Column - into a field of a form's recordsource; the field to use is specified in the combo's Control Source. You've overridden the lookup field properties by changing the row source to the target table, so you're drawing water out of a river and pouring it back into the same river! Just change the RowSourceType to "List of Values" and type in the few values you want in the RowSource property, separated by semicolons. I'd suggest changing the table field's Lookup properties from Combo Box to Textbox, as it does nothing useful in the table; just use the form combx box properties instead. [/QUOTE]