combo box selection doesn't remain on the record

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

G

I have a problem in that a combo box on a form goes to the
correct record selected, but when the form loses focus and
i return to the form, it reverts back to the first record
in the table. Is this because I am not setting a bookmark
and using it correctly? Please advise how to fix this problem.

Thank you in advance for your assistance.

G
 
I have a problem in that a combo box on a form goes to the
correct record selected, but when the form loses focus and
i return to the form, it reverts back to the first record
in the table. Is this because I am not setting a bookmark
and using it correctly? Please advise how to fix this problem.

Thank you in advance for your assistance.

G
Click to expand...

I'm not sure what the "problem" might be!

Opening a Form (unless you have DataEntry set to true) opens to the
first record in the form's recordsource. Are you closing the form? How
are you returning to the form - with an OpenForm call?


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
If I go to print it, or minimize the window to view some
other database object, then maximize the first form, it
just keeps going back to record one.
What I am trying to do, is this, I select record #5
through a combo box. it goes to that record, then I fill
in some text boxes with data that is needed to print. I go
to print, then come back to this form, and the record has
reverted to record #1.

GH
 
If I go to print it, or minimize the window to view some
other database object, then maximize the first form, it
just keeps going back to record one.
What I am trying to do, is this, I select record #5
through a combo box. it goes to that record, then I fill
in some text boxes with data that is needed to print. I go
to print, then come back to this form, and the record has
reverted to record #1.
Click to expand...

Please post the code that you use to "go to print". What are you
printing? a Report? It sounds like you're opening the form anew, or
requerying it at some point in this process.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top