Double Click to open form w/Record

[mrrayj60]

I have a form that filters down to searched records. It will narrow it down to a single or a few records, when there are a few records with the same tag# but different arrival time the user will select a specific record and double click it to go to a new form. That all works ok with one problem, it wont take the exact record he clicks but the first record of the filtered list. The record also has a unique id and I would like it to take that record to the new form.


DoCmd.OpenForm "frmVisit", , , "[License Tag Number] = '" & Me.txttag & "'"

I need something like + VisitorID added so I get the right record. VisitorID is my unique id when a record is added so its unique.
Thanks for your time. Ray

 

[pbaldy]

Can't you just use VisitorID instead of the license? Here's a reference if the data type is different:

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

 

[mrrayj60]

They use the license number to search the records to find the entry, so the same tag may have many entries but specific days they entered the park. To send a letter quoting the date and time we need to quote the right date, so I want to take that reocrd with me to the new table. Got a tip? Thanks Ray

 

[pbaldy]

If you're saying you need to use 2 fields:


DoCmd.OpenForm "frmVisit", , , "[License Tag Number] = '" & Me.txttag & "' AND OtherField = " & Me.OtherControl

Adjusting for data types of course.

 

[mrrayj60]

Perfect, Thanks...