Go to specific record on subform

[xollef]

Hello yeah stuck again.

I have a main form with lots of subforms (approx. 30) that opens with buttons. They are linked by an autonumber it is displayed on the mainform, idfield.
I want to open the subforms displaying the record that is currently in the idfield when by pressing the button.

Works almost with query involved, but hoping for easier way.

The problem if I have to make queries is that when I add info to the main it gets a new nr and the subforms gets a new nr but the nr in the subforms isn't saved before i add more information to the subform. So when I then press the button it displayes just a blank form no boxes nothing. I figure it is because only the nr isnt saved to table before there is more in values added.

 

[zambezibill]

I suspect 2 issues:

1). In design view, check the parent child links between the main form and subforms. THe links should be based on your Primary/Foreign key fields (am presuming you have included them in the subforms' recordset).

2). Make sure the queries used for the subforms' recordsets are updateable.

Cheers, Bill