473,377 Members | 1,151 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,377 software developers and data experts.

Field Properties-Combo Box/Value List/Lookup

18
Hello! I am a beginner with MS Access 2007. Creating a complex DB and need assistance on lookup columns created through Lookup Wizard with Allow Edits in table field. When a user enters a new value not listed in the lookup value list, will that value automatically be added to the lookup list or do I need to manually enter in the Field Property under Row Source? I have many more questions I will post separatly...Look forward to anyone assistance...Thank you!
May 18 '10 #1
2 2466
Jim Doherty
897 Expert 512MB
@Otter7
Welcome to Bytes :-)
Combos have a 'NotInList' event that responds to when you have 'LimitToList' property set to 'Yes' for the combo concerned. Look in the list of properties in the dialog box for that. The idea then is that you could call the 'NotInList' events sub routine to 'add' an item to an underlying lookup table for you. Below is but one example of this on this site ...search on site and you will find many more!

http://bytes.com/topic/access/answer...multiple-forms
May 19 '10 #2
Otter7
18
Wow! Went to the link and code language is too advanced for this beginner; will mark for future reference. However, thank you for the insight and clarification on NotInList event; nothing I have studied so far has not mentioned this term/event. Understand how it works now. Note: I tried UtterAccess for assistance but Bytes is easier, faster and I get my question answered with resources!!! Thanks Again!
May 19 '10 #3

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

Similar topics

8
by: hytga | last post by:
hi can n e 1 tell me if there's a way to get the column properties from a table? properties like caption, description etc thank you
4
by: Gram | last post by:
Hello, Can anyone help with the following: I wrote an ASP script with allows me to select an MS Access database from a folder, and it shows the tables in this database. If I click a table,...
2
by: dtemlak | last post by:
Hi there I am a bit new to vb.net. I have figured out how to use a data reader to get column and row information from my MS Access database using OLEDB. The problem is that while I can easily get...
2
by: Brenda | last post by:
I have a pop up form that has figures from a query. I would like the pop up form to be a display that can not be changed. I would like it to read like labels, but I do not think a label can have...
3
by: Larry | last post by:
In Access each field has individual properties (font, size, color etc). Is there a way around having to enter all these similar properties for each field. This seems so redundant. Is there a...
1
by: Andrew Smith via AccessMonster.com | last post by:
Okay here is my problem. I have a table that is imported by the user and then I need to add a boolean field to the table with Format Yes/No and the Display Control as Check box. Here is what I...
18
by: Dixie | last post by:
Can I set the Format property in a date/time field in code? Can I set the Input Mask in a date/time field in code? Can I set the Format of a Yes/No field to Checkbox in code? I am working on...
7
by: Donald Grove | last post by:
Is it possible to retrieve field properties from a table in access2000 using code? I have tried: " dim dbs as dao.database dim tbl as dao.tabledef dim fld as dao.field dim prop as...
2
by: dtemlak | last post by:
Hi there I am a bit new to vb.net. I have figured out how to use a data reader to get column and row information from my MS Access database using OLEDB. The problem is that while I can easily get...
6
by: Laetitia Clark | last post by:
Is it possible to force a Decimal type field from an ODBC source to become a Double type field in the destination table when using a Make Table query ? Thanks in advance. Laetitia South...
1
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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...

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.