473,320 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Record selection with combobox and record navigation buttons

Dear reader,

With a combobox I can go to a selected record picked in the pull down list.

And in the same time the record navigation field shows the selected record
number from the selection.

In case I go to another record by clicking the next record button the
combobox field will not by updated with the current record.

Is there any VBA code for updating the combobox field. This code is required
under the "On click" of the next record button but I do not know what to
specify.

Thanks for any help.

Kind regards,

Simon van Beek

Jan 21 '06 #1
1 3979
"Simon" <S.******@HCCnet.nl> wrote in
news:43***********************@dreader25.news.xs4a ll.nl:
Dear reader,
With a combobox I can go to a selected record picked in the
pull down list.
And in the same time the record navigation field shows the
selected record number from the selection.

In case I go to another record by clicking the next record
button the combobox field will not by updated with the current
record.
Is there any VBA code for updating the combobox field. This
code is required under the "On click" of the next record
button but I do not know what to specify.


me.combobox.value = me!primaryKey (replace combobox with the
name of your box, and replace primaryKey with the name of the
field that is your combo box's displayed column.

It is better to put this in the .OnCurrent event of the form.
This will keep the combo box syncronized no matter what method
of navigation is used

--
Bob Quintal

PA is y I've altered my email address.
Jan 21 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Xiphias | last post by:
Hi, Can someone help me to create a drop box where I can also add new records? Here is the problem: I m working on a form with a drop box. When I select a '"name" in the drop box the form...
15
by: Steve | last post by:
I have a form with about 25 fields. In the BeforeUpdate event of the form, I have code that sets the default value of each field to its current value. For a new record, I can put the focus in any...
1
by: MTrang81 | last post by:
Hello, I'm working on an MS Access Form that has a list box (Name) which display details based on my selection in a combo box (Number). Everything is working fine except when I start a new...
8
by: Zlatko Matiæ | last post by:
There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...
20
by: GAVO-UK | last post by:
Hello Everyone I have a main form (frmNewOrder) and a sub form (SubOrderBeneficiary). On the main form I have a button which sends the Subform (SubOrderBeneficiary) to a newrecord. Everything...
6
by: dbuchanan | last post by:
VS2005 I've been reading all the help I can on the topic (MSDN, other) but I can't make sense of this. Desired behavior; The user is to choose from the displayed list of the databound combobox...
4
by: Jamey Shuemaker | last post by:
Howdy, Saw a couple threads from the past few years on this topic, but didn't really find any solutions. Here's one I found:...
7
by: hubs | last post by:
Hi! I am new to Access and would appreciate some help. I am develping a browser form which provides the user a view of some data (i.e. surname, firstname, dob) from a database using a query. I...
0
by: emalcolm_FLA | last post by:
Hello and TIA for your consideration. I have created several db's for a non-profit and they want custom navigation buttons to display "You are on the first record, last record, etc". With this...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.