opening a second form based on the ID from a subform

[tonycl69]

Hi all, I have had great help from this site so hoping you can help me again.
I have a main form and sub form which work fine, the sub form is a continuous form which I want to place a command button on each line that opens another form, of which the table has not been populated yet. I would like the second form to open with the ID of the sub form at a new record, but also open up the list on the second form of previous entries if there are any.

[ranman256]

Use the Builder to the the path correct.
but it would look like,(if btn is on subForm)
Docmd.openForm "myForm",,,"[id]=" & txtID

[tonycl69]

Hi and thanks, that's not the issue, that would work if I already had entries in the underlying table to the second form, what I want to happen is when I click on the button next to the entry in the first for, for the ID filed to be populated in the second form and also be able to see any previous entries.

[ranman256]

That needs no button. It's automatic if you bound the sub form to the master form and match the keys.
just type data in the sub form.

[tonycl69]

Hi and thanks again, I already have that. I have a main form with a subform, I have a button on the subform that opens a new form, and it's this form I want the ID from the subform entered.

[orange]

What is the database about? remember we know nothing of you or your database or issue.
What do the Form and subForm represent?
What is the "other Form"?

Can you describe the process.. along these lines.
When I want to see info re:XXX I open the main Form,
then the related subForm opens and display all the YYYs that relate to the XXX on he main form.
I need to open a third form in order to display details of WWWW.

[tonycl69]

Hi guys sorry about the vagueness of the info.
Right here we go...The database is a service scheduling database, which also tracks vehicle movement, the main form open a second form that in turn opens the transfer/movement form, this is a form with a subform, I then need to open another form from that subform to show any special equipment attached or moved with the vehicle, this was the way I thought it through, but maybe there is a better solution. What is happening is the vehicle movement form is opening correct and showing in the subform all the movements that vehicle has made, but when I open the other form a popup form that does not open with the correct subform ID.

[tonycl69]

Found the solution, on the 'on current' function I pointed the ID field to the ID field of the subform.