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

[pbaldy]

How about

http://www.baldyweb.com/wherecondition.htm

[Missinglinq]

You should the page Paul gave you a link to, but note that to do exactly what you want to, you'll need to click on the link, at the bottom, left of that page, tagged

But I want to have all the records still available in the second form

Linq ;0)>

[bignate]

Thanks you both really helped me and I got it to work

[pbaldy]

No problem.

[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 & "'"

[bignate]

I found out that you can use


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