open a record from a sheet view form

[stefanocps]

Hello i have a form with seacrh parameter and a submask that will display the seacrh result
Generally i have few records, each one is a patient with datas
I would like that when i click on one record shown i will open the form where all the datas are displayed in details


So let's say the first forms is SEARCH
the sunmask os "SEARCHRESULTS"
and the one to be opened is "ANAGRAPHI"


thanks for helping

 

[theDBguy]

Hi. Check out the OpenForm method of the DoCmd object.

 

[stefanocps]

thanks, could you telle me more exactly what to do..i am not that good in code
thank s alot

 

[theDBguy]

Hi. The syntax is similar to the one you used to open a report. For example:

DoCmd.OpenForm "FormName"

To open the form to a specific record, you could add a WhereCondition argument. For example:

DoCmd.OpenForm "FormName", , , "FieldName=" & Me.FieldValue

Hope it helps...

 

[Gasman]

thanks, could you telle me more exactly what to do..i am not that good in code
thank s alot

See here
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openform

 

[stefanocps]

ok the things is that i want to open the form at the record specified
if i click on the 3rd record of the list, let's say Paul, id 3

I want to open the form at paul, id 3

 

[theDBguy]

ok the things is that i want to open the form at the record specified
if i click on the 3rd record of the list, let's say Paul, id 3

I want to open the form at paul, id 3

Hi. In case you didn't see my edit above, I offered the following:

DoCmd.OpenForm "FormName", , , "ID=" & Me.ID

In a sense, it's equivalent to this:

DoCmd.OpenForm "FormName", , , "ID=3"

Hope it makes sense...

 

[stefanocps]

Hi. In case you didn't see my edit above, I offered the following:

DoCmd.OpenForm "FormName", , , "ID=" & Me.ID

In a sense, it's equivalent to this:

DoCmd.OpenForm "FormName", , , "ID=3"

Hope it makes sense...

wonderful!!
tthanks !

 

[theDBguy]

You're welcome. Hope it works for you. Good luck!

 

[stefanocps]

it does!

 

[theDBguy]

Congratulations!