473,320 Members | 2,080 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.

Using a combo box to look up values and to enter new values

Hi,

I have a form labeled DevList and I'm trying to make it look up names
in the the "Last" column as well as be able to enter new names and
still be able to fill out the form. Can someone help me with the
coding? I think I need to use the NotInList property but I can't get
it to code right!

Thanks so much!
Nov 13 '05 #1
2 1179
What is the recordsource of your form?

- Turtle

"Amber" <am********@hotmail.com> wrote in message
news:11**************************@posting.google.c om...
Hi,

I have a form labeled DevList and I'm trying to make it look up names
in the the "Last" column as well as be able to enter new names and
still be able to fill out the form. Can someone help me with the
coding? I think I need to use the NotInList property but I can't get
it to code right!

Thanks so much!

Nov 13 '05 #2
Hi Amber,
A common problem with NotInList is forgetting to set the "Limit To List"
property to True. It is common sense in a way, but admittedly it had caught
me several times... one of those "D-Oh" moments. :-)

Don

"Amber" <am********@hotmail.com> wrote in message
news:11**************************@posting.google.c om...
Hi,

I have a form labeled DevList and I'm trying to make it look up names
in the the "Last" column as well as be able to enter new names and
still be able to fill out the form. Can someone help me with the
coding? I think I need to use the NotInList property but I can't get
it to code right!

Thanks so much!

Nov 13 '05 #3

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

Similar topics

4
by: Skully Matjas | last post by:
I am using the following code (created by the wizard) to allow to bring my form to a particular entery. But when I edit the entery (ex: put new information into a blank cell), it puts that record...
3
by: amywolfie | last post by:
Hi All: I would like to run a report based on criteria from 3 unbound combo boxes located on a parameter form (combo boxes are: cboCuisine, cboLocation, and cboRestaurant) The present code...
2
by: Mike | last post by:
Hi I have developed an application for data enty for daily production in my factory. I have one combo box for shits and second combo box for the "machine names". the third field on the form...
4
by: meganrobertson22 | last post by:
Hello everyone- I have a combo box, and I want to know if it is possible to have some sort of Message Box pop-up if a certain value is selected in the combo box. For example, I have a combo...
3
by: pelcovits | last post by:
I am trying to set up an unbound form to enter report criteria. I've followed the MS Office Assistance document: "Create a form to enter report criteria" which describes how to enter data (such...
1
by: meganrobertson22 | last post by:
Hi Everyone- I am trying to use a simple macro to set the value of a combo box on a form, and I can't get it to work. I have a macro with 2 actions: OpenForm and SetValue. I can open my form,...
0
by: Horia Tudosie | last post by:
Using Visual Studio 2003 This is to report a series of bugs regarding the FlagsAttribute and (independently) the usage of interfaces in Web applications. Let’s declare xColors type like: ...
7
by: Harris | last post by:
Dear all, I have the following codes: ====== public enum Enum_Value { Value0 = 0, Value1 = 10,
20
by: exipnakias | last post by:
Hello Guys. In a form I created a listbox which looks up the values of a table. I want: 1) ..to create a query where a parameter will be needed in order to be loaded. But I do not want to...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.