I have Form1 with combo box linked to listbox that display available "widgets" (those NOT issued). The user selects "widget" in list box and then 'tabs' to subform1 to enter EmployeeID and EmployeeName (other fields are autofilled from listbox columns.

I am trying to get the Issued field(boolean) in the Form updated to "True" after saving new record on subform. I would also like the listbox to requery so the issued "widget" is removed from the listbox and the Form is refreshed.

I have tried different methods but I cannot get the listbox to requery or the Form to refresh.

Please excuse me if this is unclear, can someone help me with this code?

I am chasing my tail at this point.

Thanks,
Chance...

Not about Me!

First, save the record on your form... if it's not saved then the table query will show the previous value(s).

From your subform:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'Note: Could also try me.recordset.update instead of above but found it doesn't always work consistently right
Forms("FormName").refresh 'Refreshes the form named
Forms("FormName").My_Combo.Requery 'Requeries for combo box content on the form named

The form refreshed and listbox requery work great. I set the event to also refocus on the combobox so the user can select next widget to assign.

Thanks for the help.

Thanks,

Chance...