trying to minimize Write Conflicts in a multi-user database

Tom,

It was your excellent article at

http://www.accessmvp.com/TWickerath/.../multiuser.htm

that launched me on this path in the first place. I've got two tables with
a memo field, and I plan to isolate them into separate 1 to 1 tables in the
coming weeks. I already took a run at it and quickly realized that I'll be
spending several weeks debugging all the changes required by the new table
structure. I thought that in the meantime, I'd take the step of loading one
record at a time into the main form, instead of multiple records.

I found your suggestion to set the RecordSource in the form's Load event to

SELECT * FROM table WHERE 1=0

to be very helpful, because now when the form loads all of the controls and
subforms are visible.

However, they, along with my combo box, are also empty. Is there a way I
could get both the combo box and the form to display the first record in the
recordset when the form first opens?

(If it requires DAO or ADO code, a dumbded-down answer in the form of the
actual code would be most welcome).

Thanks

Paul