using a form to update a listbox (1 Viewer)

[gcrutch]

I have a main form with a listbox and a command button for the listbox. When the use clicks the command button (called Carts) a new form opens for the user to enter information that pertains to the Cart. When the user enters the data in the new form and clicks save I need the listbox on the main form to update. The main form has 5 fields - SerialNbr, Status, Date, Event and Remarks. However the listbox only has the SerialNbr. So the only field I need from the new form to be updated in the listbox is the SerialNbr. I hope this makes sense.

 

[lcook1974]

When they close the form you need to "requery" the listbox.

something like:
DoCmd.close
forms!formname!listboxname.requery

http://access.mvps.org/access/forms/frm0031.htm

The link above is a great reference.

Larry

 

[gcrutch]

the listbox is on the mainform. So when I use that code on the other form of the Exit event it's not recognizing the .Requery part

 

[lcook1974]

Try putting a button that will close the form with that code behind it. Not sure it it will work on the On Exit event.

Forms!Mainform!ControlName.requery

 

[gcrutch]

I'm sorry I didn't mean on the actual on Exit event. there is a command button called "Exit" that I put the code behind. but it didn't work.

 

[lcook1974]

Can you post a sample DB?

 

[gcrutch]

i tried to upload the db but it say's "a security token is missing"

 

[lcook1974]

Did you put it in a zip file? There's a 'size' limit for uploads.

 

[gcrutch]

yes the zip file was too large...

 

[lcook1974]

compact and repair the DB...see if that reduces the size.

 

[gcrutch]

yea I did that but unfortunately it did not decrease the size enough.

 

[lcook1974]

so the form that pops up...what do you have behind the "Close" button?

it's a completly seperate form from the one that listbox is on correct?

 

[gcrutch]

here is the code behind the close button:

DoCmd.Close acForm, "Add Cart", acSavePrompt

yes it is a separate form

 

[lcook1974]

Does that form write directly to the table?

What you need to do is requery "another" form when that form closes...

So after

DoCmd.Close acForm, "Add Cart", acSavePrompt

Add

Forms!Mainform.Form!ControlName.requery

I use this code because I'm requerying a subform and it works fine where frmQualityReview is the "MainForm" sfrmIssues is the "Subform" then I focus on the the control "cmbIssue" of the subform:

 DoCmd.Close
    Forms!frmQualityReview!sfrmIssues.Form!cmbIssueType.Requery

HTH
Larry