I've searched n searched on here for the solution, mostly because I don't like to wait for someone to respond to my question
(which isn't to say I've ever had to wait real long for a response, lol).
My database contains many, many linked tables (of which I only use maybe 10) from an oracle database. In the module I am
currently working on, the user locates the contact they want to modify (address, phone number, email, etc) and clicks a
button to open a Data Entry form that drops the contact data from the oracle tables into local access staging tables, so the
user can change what they need to on the form. Later, after some QC, the staging tables will be used via tools in the oracle
database to dump the changes into the main oracle database.
That primary form (where you can only view the data in the oracle table) contains 2 subforms that pulls from another table
with the contact's phone numbers and emails/urls(typically just their email address), putting the phone numbers (business,
emergency, fax, pager, etc) in one subform and emails/urls in the other. On the new Data Entry form, the phone numbers
subform and emails/urls subform appear as listboxes.
So, once the user has made any changes to the address, the cursor tabs to the lstPhoneNumbers. I've already programmed the
DoubleClick event to open a little data entry form where the double clicked phone number is dropped into the data entry form
(another staging table) for the user to make changes. However, I also want to program so the user can simply hit enter (or
arrow down to the number they want, then hit enter) and have the data entry form pop up. It WORKS, when the user uses the
arrow key to "select" the number they want to use. But I have tried several ways to specify the default SELECTED row to the
first one, so that when the user wants to change the FIRST phone number in the list, they simply ahve to hit enter.
What am I doing wrong?
I've tried putting this
Me.lstPhoneNumber.Selected(0) = True
in the GotFocus event for the listbox, in the onLoad event for the form, nothing seems to work!