How do I select a record from within a Subform to edit

[bhecht]

I have set up a form within a form that allows the user to add records, delete records etc, while on the right there is a subform (in Table View).

How do I allow the user to click on the records in the table to bring up the relevant record in the main form?

 

[MikeAngelastro]

You usually go the other way. Selecting a parent record automatically brings up it's child records.

I don't even think it is possible to go the other way unless the subform is not filtered.

Is this what you want to do?

 

[bhecht]

Thanks

I might try and create a new form and swap them around. But even then, how do i do it?

 

[MikeAngelastro]

You could set up, using the form wizard, a column form. Thus you will be able to see a number of records at the same time on the form.

Then add a button and use it to call up another form containing the parent of the selected child. The command button wizard will help you through it.

When the form is up, there will be a button for each record.

 

[Pat Hartman]

Rather than making a subform, I usually use a listbox. If the wizards are active when you build the listbox, the third option will be "find a record on my form based on the value I selected in my listbox". That should do it for you.