Hi,
I have a database "report" that is actually a letter head statement that will be sent to different hospitals based on the donor and different procedures completed.
There will be a total of 6 people using the database.
What I want to do is have a "hidden" picture of their signature and...
I'm not totally sure...I would suspect it has something to with the fact they aren't "linked" to the main form.
This tells Access exactly where to look:
Forms!frmMasterSales!sbfUser_Default!chkCustomerCo ntactInvalidDefault=True
This is using "Me"..which I would assume "me" is...
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...
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
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