Editing 1 Record

  • Thread starter Thread starter Dianna
  • Start date Start date
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?
 
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
 
Back
Top