pass value to subform from mainform when edit data in mainform

[freedemi]

I have a mainform (frm_main) with a subform (frm_pyrovola) (linked with "id", with relationship 1-many). In subform, i have a combobox field where it takes data from table/query with the code bellow in rowsource:

SELECT tbl_apo.per_apo FROM tbl_apo WHERE (((tbl_apo.id_apo)=[forms].[frm_main].[id])); 
 

.
Everything, it is ok when I add data for first time in mainform. When I try to connect to specific record of "id" in mainform from another form which is in dataview sheet and show all data from mainform

Private Sub sys_Click()
On Error Resume Next
 
 
   DoCmd.OpenForm ("frm_main"), , , , acFormEdit
 
 
    Forms![frm_main].AllowAdditions = True
    Forms![frm_main].Recordset.FindFirst "id = " & Me.id
    Forms![frm_main].return.Visible = True
    Forms![frm_main].cmdClose.Visible = False
 
End Sub
 

I manage to find this record, but when I click the combobox, it asks for the parameter ([forms].[frm_main].[id]). I have tried several ways to resolve it, without a posittive way.
Thanks in advance.

[twinnyfo]

You nneed to requery the combo box before you try to use it:

Me.cboComboName.Requery

[freedemi]

Thanks for your answer, but same error. It asks about ([forms].[frm_main].[id]).

[twinnyfo]

When are you requerying the combo box? The error is acting like the Form is not open when it is trying to gather data in the query.

At the same time, I am a little confused by teh combo box. If your query pulls "all teh records" with ID = Main_Form.ID, that should be one record. Why not just filter your subform on the ID.

Maybe I am just confused....

[freedemi]

Sorry, but I have missed to tell you that the combo box retrieve data from another subform (frm_apo)(linked with "id", with relationship 1-many). So I have one main table (tbl_main) and two other tables (tbl_apo & tbl_pyrovola). And the combobox retrieve data from (tbl_apo).But, if in rowsource write:[CODESELECT tbl_apo.per_apo FROM tbl_apo[/code], It is ok, but I want to filter only the data with tbl_apo.id_apo)=[forms].[frm_main].[id]).

[twinnyfo]

Again, if you are dealing with records in forms, why not just filter the form? Again, I am confused about the usage of a combo box to filter a form. If the form/subforms are related with ID, there should be no need for a combo box, as every time you move to a different record in the main form, the subform filters by the ID. At least that is how is should work.

[freedemi]

Here is my database, so if you can check it.
Thanks in advance.

[twinnyfo]

I'm sorry, site rules typically prohibit posting and downloading DB projects. Either way, since I still don't understand the purpose of the combo box, I'm sure it would help me.

[freedemi]

Twinnyfo, I will show some screenshots from my db to see why I need the combobox. In the last screen I would like the combobox saw only (glock,s&w, beretta).

[twinnyfo]

I'm sorry, this still does not help me. I still don't understand what you are trying to do.

I also perceive that there may be a language barrier, too, so I am trying to firugre out the intent of your forms. But I still don't understand what your forms so and how this combo box is supposed to work.

I apologize for my slowness on this, but the pictures don't help at all, unless I know what you are trying to do, which is not completely clear at this point.

[twinnyfo]

Have you tried:

Forms![frm_main].id

I know it shouldn't matter, as Access can often disambiguate what you are trying to tell it, but this will make it clear that you are referring to another form.

But, if this is a bound control, you will have additional problems.