Form and subform from same table

R

Rod

I have built a form from a table. The form itself is
only has a combo box to select a record in a table from a
specified field in the table. The sub form then brings
up the rest of the record in the table. I can edit the
record. I then use the form to select another record and
edit as required.

The problem is when I close the form, it changes the
field (from the combo box in the main form) of the top
record in the table to have the same value as the record
that the sub/form was last on (not the record I was
editing). What am I doing wrong??

Many thanks for any help that I receive.
Rod
 
J

Jeff Boyce

Rod

Rather than using a subform to retrieve the record, consider using an
unbound combo box to select, and use the main form to display. You may be
running into a problem with a bound combo box.
 
B

Bas Cost Budde

Jeff said:
Rod

Rather than using a subform to retrieve the record, consider using an
unbound combo box to select, and use the main form to display. You may be
running into a problem with a bound combo box.
Click to expand...
One can use an unbound combobox that serves as LinkMasterFields value,
not? (This is an extremely lousy sentence, syntactically. I deeply
apologize) I saw that as a 'trick' once.

But, calling "docmd.gotorecord,,acgoto,combobox.listindex+1" from the
Click event in the combobox will do just fine.
 
Top