Current record not displaying properly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to refresh a single record in a datasheet subform? 1
Using Check Boxes to select items in an Access subform. 0
How to set color of field? 4
Access Access Report Works on One Machine but not Another 3
Default value not being displayed 5
Open form for record selected in subform 2
Datasheet combo box empty 1
split forms are not listing all my data 1

Back
Top