Edit table from form

[tjones]

I have an Institutions form. If you open it by the form by selecting it from the list, the edit command button on the Institutions form works, it opens the table and allows you to edit the table. This way you can scroll through all the institutions using the arrow on the bottom.

However, if you open it from the parent record via the command button, the edit button on the Institution form works and opens the table but will not allow you to edit the table.

The way the database is set up is that you need to go through the parent record to the child record to the grandchild record. You open the Institution form from there using an "Add" command (link) next to the field. And add a new institution but need to be allow to edit the table also but it only shows just the one record and can not scroll through using the arrow on the bottom.

 

[BBQ Kittens]

It is not clear what you are talking about (at least to me) and I am not sure what your question was..you may want to rephrase a bit

 

[tjones]

See graphic.

1. If I open the "Institutions" form from the list of forms (1 on graphic) then select the Edit command button, the table opens and allows editing.

2. If I use the "Add" command on the child form, it opens the "Institutions" form fine, but when you select the Edit command button, although the table opens it does not allow editing.

Since I will be using server login to restrict the process so you are only allowed to open via the child record I will need to be able to edit the table using process 2.

 

[Pat Hartman]

What command are you using to open frm2 from frm1?

This will open the form in edit mode. There are other options.

DoCmd.OpenForm "yourformname", acNormal, , , acFormEdit