Textbox Default Group

[Guest]

I copied a product database from a previous job. I'm trying to use the same
database for a new product line but one text box has default product
categories. I would like to change the default product categories because
the system will not let you type any other items when you add a new product.
The error message reads: No such default group. It list the existing groups
as allows only.

How can I edit the categories in this textbox.

 

[OfficeDev18 via AccessMonster.com]

Lori,

I think you mean a combo box, which is being used as a lookup. The value is
coming from either an existing table/query or from a value list, that is
typed right in the combo box's Property Sheet. Open the form in design mode,
and select the combo box. If the property sheet isn't visible, open it. Check
the Row Source property, and make changes as necessary, either in the
table/query or in the value list.

Hope this helps,

Sam

PS If you really do mean a textbox, it could be that your program is checking
the textbox contents, in the textbox's Update event, to an existing table. In
that case, simply edit the table with the correct values. SL