Populating combo box depending on value of field on form.

[suepowell]

Hi,

I have a combo box containing the names of contacts for a supplier, and I would like to populate this depending on the supplier I select from another combo box.

I am doing this using a query, with the supplierid set to the value of the first combo box.

This works fine and gives me what I want, but when I click the close buttton I put on the on the form using the wizard, I get a box asking for the value of the supplier field. This does not happen if I close the form using the X top right.

The database is in Access 2000 format, but I have Access 2002 installed on my PC now. When I was using Access 2000 the problem did not occur. I have tried converting the database to access 2002 format, and the problem still occurs.

Any suggestions? it is very annoying for the users to have to click cancel every time they try to close the form.

 

[WindSailor]

Not sure I can help... but I will try.
The syntax on the close button should be.
DoCmd.Close
If the form isn't saving before it closes try...

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.Close

Hope this helps.