Auto Lookup & Populate

[Earl Anderson]

In A97, WXP, I have an employee form which, among other things, has a
textbox for that employee's assigned access card number [CARDID]. The form
also has two (2) Yes/No checkboxes. One checkbox is to indicate whether this
is a new number (in the entire system) that needs to be added ("Yes") to a
list to be emailed to the property manager [WCCADD] and the other checkbox,
if checked "Yes", is the basis for another list to have a receipt printed
[PRTRCPT] in the employee's name for the new access card.

Presently, the person entering the data "knows" if this is a new card she is
entering and then manually 'checks' both check boxes ("Yes"). Since I've
caught some mistakes of entering newly assigned card numbers without adding
them to the list for the property manager and also not including them on the
'Print Receipt' list, I'd like to have Access automatically do a lookup to
determine if the [CARDID] is 'new' (not already in the system) and if it is
'new', check both checkboxes (Yes/-1), so I no longer must 'hope & pray'
that the boxes were checked upon initial data entry.

I would sincerely appreciate any help in showing me how to accomplish this.

Thx...
Earl Anderson

[Mike Preston]

On Mon, 19 Apr 2004 17:21:21 -0400, "Earl Anderson" <is*****@rcn.com>
wrote:

In A97, WXP, I have an employee form which, among other things, has a
textbox for that employee's assigned access card number [CARDID]. The form
also has two (2) Yes/No checkboxes. One checkbox is to indicate whether this
is a new number (in the entire system) that needs to be added ("Yes") to a
list to be emailed to the property manager [WCCADD] and the other checkbox,
if checked "Yes", is the basis for another list to have a receipt printed
[PRTRCPT] in the employee's name for the new access card.

Presently, the person entering the data "knows" if this is a new card she is
entering and then manually 'checks' both check boxes ("Yes"). Since I've
caught some mistakes of entering newly assigned card numbers without adding
them to the list for the property manager and also not including them on the
'Print Receipt' list, I'd like to have Access automatically do a lookup to
determine if the [CARDID] is 'new' (not already in the system) and if it is
'new', check both checkboxes (Yes/-1), so I no longer must 'hope & pray'
that the boxes were checked upon initial data entry.

You are on the right track. Leaving things to the user which are
pre-defined processes is a nightmare waiting to happen. You'll want
to investigate the DLookup function.

Note, however, that the DLookup function is slower than molasses
running uphill in the winter time.

Hence, if you find the response time intolerable, you might want to
investigate an alternative lookup function, such as the one described
here:

http://www.mvps.org/access/modules/mdl0012.htm, courtesy of Trevor
Best.

mike

[Robert]

Setting the DefaultValue property of a textbox will place the selected value
in that field in all new records (unless changed) and does not affect
existing records.

Robert Crouser

"Earl Anderson" <is*****@rcn.com> wrote in message
news:40***********************@news.rcn.com...

In A97, WXP, I have an employee form which, among other things, has a
textbox for that employee's assigned access card number [CARDID]. The form also has two (2) Yes/No checkboxes. One checkbox is to indicate whether this is a new number (in the entire system) that needs to be added ("Yes") to a
list to be emailed to the property manager [WCCADD] and the other checkbox, if checked "Yes", is the basis for another list to have a receipt printed
[PRTRCPT] in the employee's name for the new access card.

Presently, the person entering the data "knows" if this is a new card she is entering and then manually 'checks' both check boxes ("Yes"). Since I've
caught some mistakes of entering newly assigned card numbers without adding them to the list for the property manager and also not including them on the 'Print Receipt' list, I'd like to have Access automatically do a lookup to
determine if the [CARDID] is 'new' (not already in the system) and if it is 'new', check both checkboxes (Yes/-1), so I no longer must 'hope & pray'
that the boxes were checked upon initial data entry.

I would sincerely appreciate any help in showing me how to accomplish this.
Thx...
Earl Anderson