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

Drop down box not populating fields

Deb
I am having a problem creating a form in Access 2000 which I have done
with no problem in 97. I have an unbound drop down box. This idea is
for the user to select from the drop down box and the fields below
populate with the selected record. Then the user can make changes to
the record. The problem is that this feature works only when the form
is first loaded - one time only! So if the user selects another choice
from the drop down, nothing happens. It's as if the After Update event
is not being recognized after the first time. But it looks like it is
when I step through the code. What am I missing?!? Thanks so much in
advance!!
Nov 13 '05 #1
3 1768
Don't use afterupdate, use OnEnter. This means whenever the user clicks on
the combobox the list will automatically referesh.

HTH
Paul
"Deb" <de**********@dhha.org> wrote in message
news:bd**************************@posting.google.c om...
I am having a problem creating a form in Access 2000 which I have done
with no problem in 97. I have an unbound drop down box. This idea is
for the user to select from the drop down box and the fields below
populate with the selected record. Then the user can make changes to
the record. The problem is that this feature works only when the form
is first loaded - one time only! So if the user selects another choice
from the drop down, nothing happens. It's as if the After Update event
is not being recognized after the first time. But it looks like it is
when I step through the code. What am I missing?!? Thanks so much in
advance!!

Nov 13 '05 #2
Thanks for the tip, but OnEnter didn't work either. This caused the code
to be referenced when the cursor set focus on the drop down box instead
of waiting until an item is selected. Thanks again for taking the time
to help!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3
Sounds like you used the OnGotFocus event and not the OnEnter event. Check
again, just to be sure.

Paul

"Deb Kalisher" <de**********@dhha.org> wrote in message
news:41**********************@news.newsgroups.ws.. .
Thanks for the tip, but OnEnter didn't work either. This caused the code
to be referenced when the cursor set focus on the drop down box instead
of waiting until an item is selected. Thanks again for taking the time
to help!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #4

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

Similar topics

1
by: B. G. Mahesh | last post by:
hi In the registration form I have city, state, country fields. I was wondering if there was a database available on the net which has the list of states in each of the countries. That way when...
46
by: Kingdom | last post by:
In my data base I have a list of componet types e.g. type A - I have 8 off - type B I have 12 off etc. I'm using Set objRS = objDC.Execute("Select DISTINCT Component_Type FROM Parts_Table") ...
2
by: ehm | last post by:
I am working on creating an editable grid (for use in adding, deleting, and editing rows back to an Oracle database). I have a JSP that posts back to a servlet, which in turns posts to a WebLogic...
0
by: Neil | last post by:
Firstly apoligies if this is the wrong group. I am coding an application using ASP and a MS Access database (using Dreamweaver MX) I have two tables 'LOCATION' and 'EQUIPMENT'. The LOCATION...
1
by: J. Babe | last post by:
I am populating a drop down list with a privilege levels from a table called "Privilege" with the fields "PrivilegeID" and "PrivilegeName". In a table named "Users", their is a corresponding column...
1
by: msnews.microsoft.com | last post by:
I'd like to hear your thoughts on best methods for populating drop down list controls. I have states and countries drop down lists that don't change often, so naturally I "hard code" them in the...
13
by: Leszek Taratuta | last post by:
Hello, I have several drop-down lists on my ASP.NET page. I need to keep data sources of these lists in Session State. What would be the most effective method to serialize this kind of data...
4
by: Pete Lux | last post by:
I have a drop down that populates on page load. The drop down brings in customer numbers from my local MSDE database. It does this fine, but I click a button that finds quotes for those customers...
14
by: Philth | last post by:
Hi there, I've essentially got a form with several drop down, each populated by columns in various tables. The populating bit works fine - the column rows appear as they should in the menu. ...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
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...

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.