Current record not displaying properly

A

alaskahawk

I have a datasheet based on a query and when I double click a record I want
that one displayed in another form. Access picks the correct current record
number but the data displayed in the other form is different than that one I
selected in the datasheet. Any ideas why? I have removed all filters/sorts
to speak of.
 
J

John Vinson

I have a datasheet based on a query and when I double click a record I want
that one displayed in another form. Access picks the correct current record
number but the data displayed in the other form is different than that one I
selected in the datasheet. Any ideas why? I have removed all filters/sorts
to speak of.
Click to expand...

I have no idea. What are the Recordsources of the two forms? What's
the code in your Click event?

John W. Vinson[MVP]
 
A

alaskahawk

Nevermind, the sort order has to be exact in both the datasheet AND the form
of which I was trying to open. To do this successfully, I had to sort on two
distinctive fields, userid and ticket number...thanks!
 
Top