Hello Richard,

I am working on the last isues of my wine-database. I've normalized as much as I could (shouldn't I), which resulted in a table with almost only ID of tables like Country, Region, Winery, Winename etcetera. To add a new wine the DB has a form based on a query. This form, to avoid duplicates has comboboxes for each table, a memofield and a subfrom for the tasting note's (this last one to be able to give note's for different years of the same wine without creating duplicates).

The combo's have a "not on list" event for obvious reason.

It happens or can happen to make a typing error for example on the name of the winery. (I taste wines on a tasting event where I have only a brief glance on the bottle; the events brochure are not always correct in spelling)

So I made a copy of the form with all the fields that have an "on not in list" event. The memo and subform I can change in the "input form" as you know.
In this new form I used Textboxes to retrieve the dat from the query. This is not not working the way I expected.
I cannot change the spelling in this way, no matter what I tried.

So I came to the conclusion that the only way to make this work is by making a form for each field, retrieving the data directly from the tables. Which could then result in some froms with 2 or 3 subforms to change typing errors.

Question for the master (that's you):
Is there a better way to achieve the result I am looking for?

Thanks in advance Rick
(sending you the database might not be a cool idea; most of it is in Dutch)