Combo Box + Forms

[chadz777]

I have a form where the user can add / edit / delete information.

Well If someone they need to find/edit information on someone fast, I want to provide a drop down menu for quick access. I created a combo box named "NameList" and when I select it, it doesn't change any information on the page. Which is understandable since I didn't bound it to anything.

My problem is I do not know where to go from here. I am relatively new to access and the experience I did have, I forgot since I haven't used access in a while.

So overall, I am in need of some quick advice on properly adjusting the combo box i have to "Jump to" their information when selected.

Thanks

 

[ShaneMan]

I have a form where the user can add / edit / delete information.

Well If someone they need to find/edit information on someone fast, I want to provide a drop down menu for quick access. I created a combo box named "NameList" and when I select it, it doesn't change any information on the page. Which is understandable since I didn't bound it to anything.

My problem is I do not know where to go from here. I am relatively new to access and the experience I did have, I forgot since I haven't used access in a while.

So overall, I am in need of some quick advice on properly adjusting the combo box i have to "Jump to" their information when selected.

Thanks

Hello Chad,

Take a look at the link below and I believe this will help you accomplish what your after.

HTH,
Shane

Link: http://www.mvps.org/access/forms/frm0005.htm

 

[asad.saeed]

RUN TIME ERROR "3464"
Date type mismatch in criteria expression

Private Sub Combo_AfterUpdate()
'Move to the record selected in the control
Me.RecordsetClone.FindFirst "[FIELD] = " & Me![combo]
Me.Bookmark = Me.RecordsetClone.Bookmark

kindly solve..

 

[DCrake]

Few things of note:

a) the word FIELD should be the ACTUAL name of the field in the underlying table or query that the form is bound to.

b) the Me.Cbo value is the bound column in the combo box

c) if the field in question is a text field you do need to encompass the value in quotes, such as

Me.RecordsetClone.FindFirst "[fldName] = '" & Me![CboComboBox] & "'"

d) the name of your combo box need sto have a meaningful name not an Access reserved word, such as "Combo"

David

 

[chadz777]

ok last time i remember this being a lot more simple.

anyways, i'll try it this way, but for some reason i can't figure out how to bound the combo box to the form?

i've looked through my book "Step by Step MSO Access 2007" but can't find it...

 

[DCrake]

If you want to bind the combo box to the form then add a new combo box and go the the wizard steps. It will ask you if you want to bind it to a specific field in your underlyng table/query.

David

 

[asad.saeed]

Ther is a error 3464
format of [Numberingscheme] is number if I change it to text then its working. But i have to use it as a number

This is a code

Private Sub Combo8_AfterUpdate()
Me.RecordsetClone.FindFirst "[Numberingscheme] = '" & Me![Combo8] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub

kindly solve this matter urgent
Thanks in advance


Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub