Update Event

[ladybug via AccessMonster.com]

I have a form called sfrm_status_of_lif2. In this form are two combo boxes,
status and sub_by. Third there is a text box, status_dt. Then there is a
command button called cmd_notes.

When this button is clicked another form opens up called
sfrm_status_of_lif_notes. The three boxes appear on this forms header and
the data entered from sfrm_status_of_lif2.

The problem is if I tab to the cmd_notes button after entering the status,
sub_by, and status_dt the info is not in form sfrm_status_of_lif_notes. If I
tab off of the form and then click on the cmd_notes button then the
selections are there. How can I get this to update once you click the button
before the form opens?

 

[Al Campagna]

ladybug,
Try a Refresh just before opening the second form.
The values you entered (status), has not been written to the table yet...
no update has occured yet.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."