Editing 1 Record

D

Dianna

I have a subform listing only in-work records. The form
has a drop down box containing the record numbers below.
I want the user to be able to select one record in the
drop down box that needs to be edited. The data entry
form containing the information for that record needs to
be displayed for editing. Any suggestions?
 
G

Gerald Stanley

In the ListBox's AfterUpdate eventhandler, you should put
in the code

DoCmd.OpenForm "{yourFormName}",,,"{yourColumnName} = " &
{yourListBoxName}

You will have to replace {yourFormName} , {yourColumnName}
and {yourListBoxName} including {} with your own
appropriate names.

Hope This Helps
Gerald Stanley MCSD
 
Top