Form/subform, Is it possible?

[Luka]

Hi,

I have main form with subform. Is it possible to open form on specific record, like main form ID = 2, and then add records to subform? I keep getting error (Changes were not succesful... error 3022).

For example: I would like to open form Invoce and I want it to open on Invoce number "2". Record number "2" was entered before this opening. That also mean that I get data on subform that are connected with Invoce number "2". Now the question is: Is it possible to add a new line in subform?

Thanks in advance.

 

[SamDeMan]

not so sure what your question is. do you that the main form and the subform relate to the same record? then you need to link them.

please explain,

sam

 

[Luka]

Form and subform are linked (Parent/Child with ID fields) and that works fine.

I would like to open a form on a specific record from table. When the form is opened this record is shown on a form and subform, because of one to many relationship (like filtering records). Now is it possible to add a new record in subform which already have some data.

 

[SamDeMan]

docmd.gotorecord..

never used it, but i think thats what you want.

good luck,

sam

 

[Luka]

Problem is that, when subform gets focus the error displays

 

[Luka]

Problem solved.

Solution is Filter

Thanks Sam