Prev: Forcing New Page
Next: nested iif statements in a query
From: Linq Adams via AccessMonster.com on 25 Mar 2010 09:38
Bob Quintal wrote:
"Using the Load event means that EVERY user will be shown as the USER
in EVERY ROW that is looked at, as well as the ones that do get new
data entered."

Actually, placing this in the Form_Load event will only effect the first
record displayed, not every record!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

From: Bob Quintal on 25 Mar 2010 17:02
"Linq Adams via AccessMonster.com" <u28780(a)uwe> wrote in
news:a589aae4ce2b7(a)uwe:

> Bob Quintal wrote:
> "Using the Load event means that EVERY user will be shown as the
> USER in EVERY ROW that is looked at, as well as the ones that do
> get new data entered."
>
> Actually, placing this in the Form_Load event will only effect the
> first record displayed, not every record!
>
If the load event places the data into an unbound box, and code in
another event writes it to the table, it will affect every row.

--
Bob Quintal

PA is y I've altered my email address.
First  |  Prev  | 
Pages: 1 2
Prev: Forcing New Page
Next: nested iif statements in a query