Capturing Values?

[FlashG]

How can I capture the current value of a field with a button on a form so that I can open another form and filter the records based on the value?

e.g. I have a task table and a parts table
Each task may have several parts defined by their
TaskID(the common field in both tables)
On my partsView form I would like to place a button 'View Parent Task' which would open the taskView form with the related task that corresponds with the current record in the partsView form.



[This message has been edited by FlashG (edited 12-06-2001).]

 

[Jack Cowley]

Use the Wizard to create your button. About the 2nd or 3rd screen you will be asked if you want to open the form to a specific record. Select that radio button and finish the Wizard. That should do it for you....