Form and subform from same table

  • Thread starter Thread starter Rod
  • Start date Start date
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
 
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.
 
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.
 
Back
Top