[Pages] Dropdown List Navigation Help

[Mat1024]

Hi everyone,

I am having trouble designing a page with Access XP (2002), and
would really appreciate your help.
I want the page to be used to add new entries to the database or
to update the existing entries.

I run the wizard, choose my table, select all fields, no levels,
no sort order and here it goes, the page is created.
The problem is about the navigation: I can only navigate through
the fields ONE BY ONE with this basic menu at the end of the page,
and it takes ages to attain the 532nd field on a 739th fields
database

The ideal would be a dropdown list, but I cannot find a way to
implement it so that when you click on field inside, all the
other fields follow up.

Example:

Firm1|2%|0.3%|9%
when I click on firm2 in the dropdown list it goes
Firm2|2%|0.3%|9%

The other fields do not change... do you have any suggestion?

Thankyou very much!

 

[dopedealer]

Check attachment.
Chris

 

[Mat1024]

Thanks a lot !!!

This is an excellent source of inspiration.

 

[Mat1024]

I need help, I don't understand the code you use:

Private Sub Combo16_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ID No] = " & Str(Nz(Me![Combo16], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

I tried to adapt it to my database, but I have runtime error 13 type mismatch

Private Sub FundsCombo_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Funds] = " & Str(Nz(Me![FundsCombo], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub


FundsCombo is the name of the combo box
Funds is the data (text)

What can I do?

 

[dopedealer]

Delete the Combo Box and add a new one, when your adding it you will see the wizard come up with 3 options, the third option says "Find a record on my form based on the value i selected in my combobox" choose that and then the table which you want the control to "Control", also choose the fields you want in the Combobox, ideally the primary key and another field of your choice and voiala that should work. However if you dont succeed send me your database and i ll fix it for you.
Chris

 

[Mat1024]

of course.... thanks a lot! it works perfectly fine now!

By the way, do you know how to put the combo box in read only to avoid adding entries by error?

So that when you press a letter it goes to the entry (for example you press 'z' and it goes to "zanit"), without having the chance to create an entry if you press enter of anything.

Thankyou very much for your help,

 

[dopedealer]

I am not sure i follow what your saying, Anyhow, the combobox is already READONLY. The other thing you mentioned where entering "A" will bring up "Alex" is called Autocomplete and you can enable this in the properties of the Combo Box.
Chris