Update record in code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help w/ List Box

A tblProduction table w/ fields; Contact Name, Company Name, 1st Owner Name,
2ndOwner Name was created. Each record must be update w/ Company Name,
Contact Name and 1stOwner.

A List Box is used to update 1stOwner field. The List Box selections include
(1) "Selection Required" (2) 10%Owner, (3) 20%Owner (4) 30%Owner and so on.

Problem; when a record is update using the List Box, the List Box retains
the previous selection, thus the next record is updated w/ the previous item
selected. This requires a manual change. How do we have the system using VBA
code return the List Box to "Selection Required" choice? Thus, updating the
next record w/ "Selection Required" statement.

Thanks
RD
 
You actually need to "reset" the listbox after each new record is
created; to achieve this, you need this line of code right after the
code section that creates the new record:

Me.YourListBoxName = "Selection Required"

HTH,
Nikos
 
Back
Top