473,785 Members | 2,325 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4012
"Simon" <S.******@HCCne t.nl> wrote in
news:43******** *************** @dreader25.news .xs4all.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.val ue = 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
2056
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 will change to that record. This is ok
15
4662
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 field to start. If I edit that field and then click on the new record button in the navigation buttons, the form goes to a new record and each field has the default value of the previous record. If I put the focus in any field to start, edit that...
1
2201
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 record. The list box (Name) still displays the previous selection's details. For example, for my first record, I choose F181 from my combo box. My list box will display "North Iowa". I finish filling out the rest of the form and go to the 2nd...
8
12106
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 combobox. What is the solution? Thank you in advance.
20
2271
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 works fine expect that when I press the button, the controls on the subform display an #Error for a fraction of a second when changing from the current record on the subform to the new record and theneverything works fine. Does anyone knows how...
6
2883
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 and the coresponding 'Id' from the lookup table is to be inserted into the field of the new record. I have two simple tables. "tblPerson" is the data table. The lookup
4
2906
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: http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/f6ccff0186d12566/ That fella wanted to do pretty well the same thing I did (use a command button to move between records in a form). Moving from record to record
7
2760
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 am trying to replace the standard system navigation bar with my own buttons which allow the user to click on it and move the record selection to "next" or "previous". I don't know how to attatch an image file to this message which would better...
0
1958
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 ng help I've created code for all except the add new record command button. If I create individual sub functions behind each form, no problem. The problem is I am trying to create a re-usable module.
0
9645
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10341
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10155
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9954
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8979
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7502
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5513
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4054
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3656
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.