Open form to a specific patient

[raphael99]

I have a Form (FRM_SEarchMulti) with a list box (SearchResults). This list box has an ID for patient.
I have a form (FRMMeseCorrentePrestazioni) with a command button that open another form (FRMPrestazioni).

I would like to be able to open FRMPrestazioni based on the specific record of listbox SearchResults.

I used

DoCmd.OpenForm "FRMPrestazioni", , , "ID = " & FRM_SearchMulti.SearchResults.ID

with no success

 

[vbaInet]

with no success

What does that mean exactly raphael99?

 

[pbaldy]

Doesn't look like your syntax to refer to the form is correct:

http://access.mvps.org/access/forms/frm0031.htm

 

[raphael99]

What does that mean exactly raphael99?

I got error 424 object required. Modified this way:

DoCmd.OpenForm "FRMPrestazioni", , , "ID = " & FRM_SearchMulti.SearchResults.Column(6)

still error 424

 

[raphael99]

@Baldy. Is not a subform!

DoCmd.OpenForm "FRMPrestazioni", , , "ID = " & FRM_SearchMulti!SearchResults.Column(6)

still error 424 object required

 

[pbaldy]

@Baldy. Is not a subform!

DoCmd.OpenForm "FRMPrestazioni", , , "ID = " & FRM_SearchMulti!SearchResults.Column(6)

still error 424 object required

I didn't say it was.

Forms!FRM_SearchMulti!SearchResults.Column(6)

 

[raphael99]

Works very well . Thanks a lot

 

[pbaldy]

Happy to help!