Filtered form/subform advice needed

[2ShotLatte]

I have a form, frmRA. Users open form and select an employee from a combobox (made using the wizard, Combo86) this updates frmRA with employee data. frmRA has a subform, subfrmNote, that lists notes on an employee. Users can double click, which runs an On Double Click event (DoCmd.OpenForm), a row on subfrmNote to review the note details on form, frmNoteReview. This opens the frmNoteReview filtered, showing just the recorded selected.

Here’s where I’m stumped -
First, I need users to edit the information on frmNoteReview after the double click event.

Second, I want users to have ability to add a new note from the main form, frmRA, by clicking a command button (Command88). Currently this opens the form filtered for the employee selected from the Combo86.

Any thoughts on how this can happen? Or am I completely off base?

Thanks
-steve

 

[HNA]

Hi,

When The User DblClick On blablabla, Dose This Form Open As Editable?
Can U Send Me Ur DB To Do That While I Have No Enough Information About Uniqe ID's.

Saam001@yahoo.com

Good Luck

" Åä Çááå íÍÈ ÅÐÇ Úãá ÃÍÏßã ÚãáÇ Ãä íÊÞäå "