Open particular record in a form

[bignate]

I have a continuous form that is based on a query. I would like to have an open button so that you can select a record on the form and that particular record opens up in a new form. How do I do this?

If this cant be achieved would I be able to make a form open that shows a particular record based on the query and you just press next record to view the other records that are a result of the query?

Thanks

 

[pr2-eugin]

Have you checked Open a second form to the record selected on the first form

 

[CuriousGeo]

How about using a command button that will open the form to the selected record, there is a wizard that will assist you. I cannot post hyperlinks, but there is a good tutorial on youtube. Search for this video "Microsoft Access Open Form to Specific Record" by 599CD computer training.

 

[bignate]

Thanks both of you, you both suggested the same thing but I used the link that pr2-eugin suggested

 

[bignate]

Hi I decided to use the first way where you only see one record. I currently make it open to a Time Reported field which will be unique for everyone. However I wanted to know if its possible to have two fields for the restriction to be based on. Just incase in the rare circumstance that two records were created at the exact same time. I wanted it be something like this:
DoCmd.OpenForm "UpdateRecord", , , "[TimeReported] = #" & Me.TimeReportedUFO & "# " "UpdateRecord", , , "[Full Name] = '" & Me.FullNameUF & "'"

 

[pr2-eugin]

Yes you can. Use the And operator between the two criteria, adapt the following to change.

Dim whrStr As String
whrStr = "[TimeReported] = #" & Me.TimeReportedUFO & "# [COLOR=Blue][B]AND [Full Name] = '" & Me.FullNameUF & "'"[/B][/COLOR]
DoCmd.OpenForm "FormName", WhereCondition:= whrStr

 

[bignate]

Thank you
I thought I would have to use 'And' but I wouldn't have known you had to declare a variable