473,396 Members | 2,076 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,396 software developers and data experts.

How to assign an initial value to an unbound combobox

Hello,

New to Access/VBA so I hope this question is fair. Continuous form displaying multiple records. I tried implementing a bound combo box utilizing on change code to narrow a user search as values are entered. Builds a wildcard based sql statement and applies it to rowsource. Works great except when the first character is entered Access seems to fire a query and a single user is loaded before entering the on change code. I have to backspace to clear this value and then only the characters entered are referenced in the on change code. Making it unbound works great but I do not know how to set the initial value as stored in the database. Any recommendations?

thank you,

Scott
Oct 1 '10 #1
1 1827
Mr Key
132 100+
Wecome Scot!
It seems you are doin great with access, may you please attach the sample of your design so that we can understand much better of what you are trying to tell us!!
Oct 2 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: TekWiz | last post by:
I've got a system that automatically generates a form. I have it set up so that the backend will return to the inital form page with an error object in sessions data (assuming the backend detected...
8
by: Lyn | last post by:
Hi, Can anyone tell me how the initial value displayed in Combo Box is determined when a form is opened? I am loading the dropdown from one field ("CategoryName") of a table, with "ORDER BY ". ...
2
by: Susan Bricker | last post by:
Greetings! Still the same application (as previous posts). I worked on the app while at work (don't tell my boss ... cause this is just for fun and not work related) and the form was working,...
2
by: dskillingstad | last post by:
I'm trying to assign a custom value to a textbox. Here's what I have. I've created a module and "default value" code for a textbox which generates a custom auto-number (yyyy-0000) when a New...
4
by: toufik | last post by:
Hi, In the ValueChanged event of a dateTimePicker control I've a condition, and I like to reset the initial value if teh condition is false Private Sub dateDebut_ValueChanged(ByVal sender As...
2
by: Bill nguyen | last post by:
I need help to set selected value of combobox column in DGV. I went this far then got stuck on what to do next:. How do I set "selected Value" of comboboxpayCode to value of column PayCode ?...
1
by: sfindlay | last post by:
I have two comboboxes in an unbound field: - finds Vendor ID, and from this list finds Application ID using Vendor ID as the filter. The application details are populated in a subform bound...
3
by: greeknl via AccessMonster.com | last post by:
Is possible to save to a variable in VBA the value a combobox had before it was updated in order to use it because the update value can be retrieved easily Thank you -- Message posted via...
8
by: lttan123 | last post by:
hi there i am having some difficulties to bind value to combobox in windows application. combo.Items.Add(new List("a","b")) I have created a class. The value is there but what is displayed...
1
by: Scott Spaman | last post by:
Continuous form – bound combo box utilizing on change code to narrow a user search as values are entered. When the first character is entered Access seems to fire a query and the on change code...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
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,...
0
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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,...

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.