>> - Does a test copy of form work seamlessly with a different test table (free
>> or in a different DBC).
>I tried to eliminate the DBC complitely, use the table FREE, EXCLUSIVE or not: No success.
Totally different table, same form and still error ? It sounds underlying code is faulty.
>
>> - While textbox and combo both have same recordsource, what buffering is set,
>> are transactions in effect, what is rowsourcetype for combo etc etc
>There is no buffering since the rowsourcetype of the combobox is an SQL Query. In my program, I use the standard wizard BUTTONSET. I think it use transaction.
Standart wizard set doesn't use transaction but uses buffering. Turns textboxes to RO when not in edit but doesn't touch others as standart (there is an option to make RO for all).
>
>> - Type of combo and is textbox RO or RW.
>The textbox is RW, The combo is List only (i can not write in it).
Textbox controlsource ? Is there one ? Would operate on current rec if so.
But I don't think it has one. Otherwise you would be unintentionally changing ID (as I remember textbox and combo had same recordsource).
Here really my mind is confused. If the textbox and combo (which I think is a lookup listbox) have same table as recordsource and textbox has a controlsource as ID, you would be playing with current rec's ID and most likely duplicating a primary key. If this is really the case just setting textbox controlsource to "none" should cease the problem.
>
>> In textbox you enter an ID and perform a seek ?
>I do not have to perform a seek since the ComboBox have an SQL Query as RowSourceType, I simply set the ComboBox value with the ID entred in the textbox.
Back to the future :) SQL rowsource, nice I always liked it. So in fact they don't have same recordsource.
I wonder if we are incorrectly concentrated on textbox+combo. For publishing it you have choices :
-For a partial publish, provide textbox and combos properties such as controlsource, rowsourcetype, rowsource etc. + methods of them.
-For a full publish, go to class browser, set form as file type, select your form. There "view code" and copy&paste all.
-This last option is the most practical one and hope won't be crude for rest of members. Zip and email the form with at least partial data.
PS: I have great tendency to say drop listbox and use grid :)
Cetin