Form Editing my Table

[derek7467]

Greetings all!

I built a form that displays my table. I turned Tab Stop off on all but a name that is a combo box limited to a list. For some reason, that name field is editable, which i turned off but... Now when i click the dropdown i can hover over a name, but cant click it. I can click it when i allow the field to be editable. This is trivial, can someone point me to the property to set?

[June7]

By 'turned off' do you mean set as Locked Yes? Why would you want to click a dropdown on a non-editable combobox? Can't have it both ways. Only editable combobox will allow click to select item from list because that is one way to edit the combobox.

[derek7467]

yes its locked for editing. i want it so that i ca click the dropdown and view the record for whatever i click on. I know its possible because its acting like i want in another form ive seen built by someone else. only difference is that there is vba code on the onload fucntion. i havent looked at that code yet

[June7]

What do you mean by 'view the record'? You want to go to record or filter the form based on combobox selection? That must be an UNBOUND and unlocked combobox.

[derek7467]

i want to make the selection and filter the form based on that selection

[June7]

Then unlock the combobox and don't bind it.

What method are you using? Options:

1. dynamic parameterized query as form RecordSource

2. set the Filter and FilterOn properties of form

3. go to record

[derek7467]

i wasnt binding it. i was setting it in the combo box settings to find values on form by it. i will try ur options and see how it goes

[Missinglinq]

If the list of names is short enough that you can live with the users having to scroll down to the name, rather than beginning to enter a name in and having it move to the appropriate name, you can leave the Combobox unlocked but prevent keyboard input, using code like this:

Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
 
 Select Case KeyCode
  
 Case vbKeyReturn, vbKeyTab, vbKeyUp, vbKeyDown
   KeyCode = KeyCode  'Accept these keys
 
  Case Else
   KeyCode = 0 'Block all other keys
 
End Select

End Sub

Linq ;0)>

[derek7467]

what action should i put that code on?

[June7]

Linq's code is in the KeyDown event of combobox. Create the event for your combobox and paste the code into it.

Do you know how to create VBA event procedures?

[derek7467]

thanks guys, i added the code in, but it wasnt what i wanted so i sat for a minute and thought about my issue. IT WAS BOUND! I made it unbound and now i can use the drop down field and nothing is getting edited. Next issue is tab to next record stopped working. Anyway to make both the drop down and tab work together? (tab property is set to NO on all but the employee combo box which is set to Yes