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

dlookup--after update help

=DLookUp("[CompanyName]","Model Data","[CompanySymbol]='" & [Ticker].[Value]
& "'")

This formula works...it pull the company name, matching the Ticker put into
the Ticker field. So putting in IBM will pull its name from the Model Data
table and show it in the TickerName field of my form..form name DataEntry.

So I thought it would be easy to get this to activate only after data was
entered into the Ticker field so I simply put the same formula into the
"afterupdate" control on the form...Doesn't work...can anyone give me a
suggestion on this?

--
Message posted via http://www.accessmonster.com

Jan 30 '07 #1
1 2026
what is an "afterupdate" control?
"mindlike via AccessMonster.com" <u31229@uwewrote in message
news:6d0882b2bd8ad@uwe...
=DLookUp("[CompanyName]","Model Data","[CompanySymbol]='" &
[Ticker].[Value]
& "'")

This formula works...it pull the company name, matching the Ticker put
into
the Ticker field. So putting in IBM will pull its name from the Model
Data
table and show it in the TickerName field of my form..form name DataEntry.

So I thought it would be easy to get this to activate only after data was
entered into the Ticker field so I simply put the same formula into the
"afterupdate" control on the form...Doesn't work...can anyone give me a
suggestion on this?

--
Message posted via http://www.accessmonster.com

Jan 30 '07 #2

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

Similar topics

6
by: Paul Eden | last post by:
Hello all. I'm totally stumped. Please de-stump me! I've read my data in from the database, changed it according to what i want to do and now I want to write it back. But it seems I can only...
1
by: MattMika | last post by:
I am trying to integrate a Credit Card # deletion option into Batch_print_center and need some help. Batch_print_center has a form where you specify orders you want to print or proccess by...
8
by: Jason | last post by:
I have a table that matches up Securities and Exchanges. Individual securities can belong on multiple exchanges. One of the columns, named PrimaryExchangeFlag, indicates if a particular exchange is...
7
by: Steve B. | last post by:
Does anyone know why the DA Update() would throw an exception? I moved the database but I updated the Conn and the DA, currently (trying)removing/replacing DS. Is there a another direction I...
0
by: Ash | last post by:
Hi, I'm using Vb.NET webform, connecting to sql server database on the local machine. I used datagrid propery builder to add the edit, update and cancel colum. On the code, i have: Private...
4
by: Mike | last post by:
I have an update page and on the page there are sometimes names with 's (car's) in it When I try to update it i get a syntax error. How can i update the record with a 's (car's) in the name? thx
2
by: billr | last post by:
SQL newby in deep water thats way over my head. Any help appreciated. I am trying to retrieve data from field in one table and append it to on field in a second table. Each the fields had a Field ID...
0
by: Mangler | last post by:
I have a form that does multiple updates on the page. For some reason that I cant figure out it is redirecting before the update is done. It doesnt do this on another page that I have. <% If...
7
by: wizardry | last post by:
i can query the list fine using: select list.list, many_table.list_id_fk from list left join many_table on list.id = many_table.list_id_fk and many_table.userid = 'UserId'; that populates...
1
by: donken | last post by:
Hi I'm trying to update changes made in a dataset to an existing .dbf file. But I can't figure it out. I connect to the file via ODBC connection and the updates to the DataSet works fine but then...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: 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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...
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...

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.