Focus problem with a sub-form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I bulit a new form with a couple of sub-forms. Actually the head form
doesn't contain any data (record-soucre). Layout for the sub-form is
'Tabular' and the data-soucre of the sub-form is data of a table. In fisrt
the table contain a primary-key that just contain 1 datafield. So when i add
a new record in the sub-form, i just use the function Docmd.FindRecord to get
the new record that i added before. What i then need to do is display the
primary-key in the sub-form.

The problem from now is the datatable of the sub-form get some modify. The
primary-key of this table with contain 3 datafields. So the function
"Docmd.FindRecord" doest not seems to work anymore. Do anyone have an idea to
solve this focus-probleem?

Best regards & thanks!

Groeten,

Pat
 
Hi Pat,
I would get rid of the docmd.findrecord and give your main form the same
record source as the subform, and incude the key fields on the form - you
can set them to not visible after - then use them as master & child link
fields for your subforms.
 
Back
Top