Search Function

[sk88]

So I have a search form called ‘fdlgSearchPatient’


It is a search-as-you-type function. The function works fine so far.


Now I added EDIT and ADD NEW button but I don’t know how to link it.
I would like the FrmAuditTool to be pulled up when the user hit EDIT and frmNEW when the user hit ADD NEW button.

How do I make this work? The search as you type codes were simply copied from an online example.



Please see the attached file for what I have created so far.
Thanks!

[aytee111]

Firstly, why do you need those two extra forms? If you use tblAudit as your record source for the subform then you won't need either of those two buttons. You can allow the user to edit as well as add new directly on the subform.

Otherwise, OnClick for the two buttons, open the form (VBA - or use a macro)
DoCmd.OpenForm "formname"

[sk88]

Firstly, why do you need those two extra forms? If you use tblAudit as your record source for the subform then you won't need either of those two buttons. You can allow the user to edit as well as add new directly on the subform.

Otherwise, OnClick for the two buttons, open the form (VBA - or use a macro)
DoCmd.OpenForm "formname"

The reason I have two forms is because one when open takes the user to NEW FORM.. whereas one is linked to the old data.

Basically to prevent users from going to EDIT form and add NEW within the EDIT FORM.